Mar 07 2022 08:26 AM
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.
Mar 07 2022 08:38 AM - edited Mar 07 2022 08:39 AM
@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.