Completing Formula For Hours Worked

[it''''''''sh hardy]

Hello! -
I have an excel sheet that is totalling for hours worked, but if someone
works over 24 hours, the total starts over from 0 hour then again up to 24.
How do I format this cell to properly equate what the total hours worked is?

1:35
10:10
0:17
0:52
2:18
5:23
3:36
3:14
0:21
1:57




Total 5:43

 

[Jacob Skaria]

Right click the cell/range>Format Cells>Select Category as 'Custom'. Within
the text box labeled 'Type:' enter the below

[h]:mm


If this post helps click Yes

 

[Ms-Exl-Learner]

just format the cell which consist the total with the below mentioned format.

Now your cell will have the formatting as h:mm
Place the cursor which consist the total of the time values Do Right
Click>Format Cells>Number>Custom and apply the below format.

[h]:mm

Change it from h:mm to [h]:mm.

If this post helps, Click Yes!

 

[David Biddulph]

Format as [h]:mm
The square brackets are significant.