Forum Discussion
How to count the number of hours worked on a shift past midnight
For instance, if an employee comes in at 10:35pm and leaves at 7:15am, is there a formula which returns the total number of hours worked after midnight? I need to know exactly how many hours are wor...
grayforensic Use this:
=MOD(end_time-start_time,1)
Replace the words end_time and start_time by cell references or your own named ranges.