Calculating Total Hours & Minutes Worked
I can't figure out how to calculate the total of hours in Excel (365).
Begin End Hours
8:30 AM 4:16 PM 6:24:00 PM
8:00 AM 4:15 PM 6:00:00 AM
8:02 AM 3:52 PM 8:00:00 PM
6:00 AM 6:00 PM 12:00:00 AM
8:02 AM 2:10 PM 3:12:00 AM
Total Hours: 25095600=SUM(C4:C8)*24
Thanks in advance in assisting me with this total formula or the correct formatting.
K
Last edited by aaghd72; 04-12-2019 at 01:52 PM.
Reason: Changed Excel Version
|