![]() |
|
|
|
#1
|
|||
|
|||
|
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 |