Forum Discussion
Using IF with hour formed cells.
I need to make a condition: If entrance hour is between 22:00 and 05:00... How can I do it using if or ifs formula? Excel 365 Thanks.
- True is when an entering time is between 22:00 to 05:00.
- Is there a way to check with a formula if an employee worked 2 hours or more between 22:00 to 05:00.
In the file attached to this reply, Jimmy and Ronni suppose to be "TRUE" and the rest should be "False".
