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 worked on each calendar day. Any ideas? The Excel spreadsheet has 77,000 rows.
1 Reply
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.
