#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Please post a sample sheet ( no pics) with some data and expected results
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Simply sum column Hours, format the cell with formula like "[h]:mm:ss" (NB! Mark square brackets in formula, they are essential.), and there you are!
You also can use "[m]" (returns minutes), "[s]" (returns seconds), etc. |
Tags |
excel 365 |
|
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 |