Hello,
I need urgent help regarding formula for time, I'm still new with excel so I'm not sure which is the best one.
If possible with condition formatting so it's not too complicated.
Let say, the schedule time are these: 7:00 am, 8:00 am, 9:30 am
If actual log in time match the schedule time then I want it to highlight.
And if actual log in time is: 7:01 am, 7:59 am, 9:35 am - I also want to highlight all the actual time that didn't match the schedule time.
How would I do that it base on the minutes not the hour?
Bookmarks