View Single Post
 
Old 04-12-2019, 01:52 PM
aaghd72 aaghd72 is offline Windows 10 Office 2019
Novice
 
Join Date: Feb 2019
Posts: 15
aaghd72 is on a distinguished road
Question 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
Reply With Quote