Check if a time is within two times (using first time as the starting time)

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:

Please Login or Register  to view this content.

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

This is one step closer... adding the additional if statement changed 20:00, 21:00, 22:00 and 23:00 to YES (perfect) but it did not change 00:00, 1:00, 2:00 or 3:00.

time.jpg

Does it help that I know the number of hours they are working (Column B) along with the start and end times? I know if they are working 8 hours (Column B), can this be combined with the start time to determine where the range falls? I also know if the hours overlap into the next day (past midnight) (Column C).



Craig

Yes daddylonglegs formula worked great... much appreciated to the both of you.
Now I will decipher to see how it works.

Thanks again to the both of you!

Craig