|
|
#1
04-12-2019, 01:52 PM
|
|||
|
|||
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 
|
| Tags |
| excel 365 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Calculating multiple fields to calculate to the total hours
|
stewbinson | Excel | 1 | 01-22-2017 10:18 PM |
|
Hours Worked - AM and PM
|
franco9999 | Excel | 3 | 11-23-2016 09:25 AM |
|
how to find out hours worked between midnight and 6 am
|
acorn | Excel | 2 | 10-15-2016 01:45 AM |
|
Very complicated calculation of total hours worked (PLEASE HELP)
|
APreston | Excel | 1 | 05-08-2016 02:58 AM |
|
Help with 'hours worked' calculation...
|
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
Windows 10 
Office 2019
Threaded Mode