Hi there, I am having some difficulty checking to see if a time is within two other times, I need to use a start and end time. The code I am using checks from the lowest to the largest time values. Note: I minus off 15 minutes so the last time value isn't true.
I am using the formula below:
This works as long as the ending time doesn't go past midnight.
As you can see in the image, all hours are being recorded properly except for John... his hours have been picked up in reverse. I need his hours to show 'YES' for 20:00,21:00,22:00,23:00,00:00,01:00,02:00,03:00.
time.jpg
Is it possible for me to do this?
My goal is to count the number of people working during each hour of the day... for scheduling verification.
Thanks
Craig
Bookmarks