I have attached an example sheet for reference..
Basically what I want is if the appointment date and appointment time in cells D3-D7 and E3-E7 are a match to the current date, the customers name appears in the schedule in cells I7-I16 dependant on what time it is.
Being the excel noob that I am, I wouldn't even have a clue on where to start!