Compare hours in Excel
Solved
vérité
-
zinoure Posted messages 14 Status Member -
zinoure Posted messages 14 Status Member -
Hello,
thank you for helping me.
I have two time slots from 6:00 AM to 9:00 PM and from 9:00 PM to 6:00 AM.
When I enter a start time in cell A1 and an end time in B1, if both times I entered fall within the interval of 9:00 PM to 6:00 AM, then cell C1 displays a value of 1; otherwise, it displays 2.
the
Configuration: Windows 7 / Firefox 35.0
thank you for helping me.
I have two time slots from 6:00 AM to 9:00 PM and from 9:00 PM to 6:00 AM.
When I enter a start time in cell A1 and an end time in B1, if both times I entered fall within the interval of 9:00 PM to 6:00 AM, then cell C1 displays a value of 1; otherwise, it displays 2.
the
Configuration: Windows 7 / Firefox 35.0
