How to count the number of hours worked on a shift past midnight

Occasional Visitor

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.