Thank you to all who responded. The formula did work after changing the format.


"Joe User" wrote:

"da" wrote:
I changed the format as suggested. But, I still get
total 9 hours and 20 minutes, which is worng.

First, it might not have been what format should be changed. Change the
format of the cell where you compute the sum to [h]:mm.

Second, it is not clear how you computing the sum. I ass-u-me you are using
=SUM(A1:A42).

When copy-and-paste the column of posted numbers and compute SUM in a cell
formatted as h:mm, the result is displayed misleadingly 6:15, not 9:20. It
displays correctly as 78:15 with the format [h]:mm.

So I wonder if some of your times are entered as text instead of numbers.
SUM will ignore the text. I suggest you enter the formula in the form
=ISNUMBER(A1) in all cells in a parallel column. Be sure that the results
are all TRUE.

An alternative explanation is that you simply have some typos in the data
that you posted.


----- original message -----

"da" wrote:
Thanks
I changed the format as suggested. But, I still get total 9 hours and 20
minutes, which is worng.

"FSt1" wrote:

hi
try format [hh]:mm:ss

Regards
FSt1

"da" wrote:

Hello
I am not getting total sum when trying to add following times. I have used
H;mm format. I get total of 9:20, which is wrong. How can I get accurate
total?
Thanks
1:50
0:45
0:40
2:40
1:40
0:20
0:30
0:00
1:30
0:25
2:40
2:30
2:30
2:40
0:50
1:05
2:15
4:00
1:20
2:40
0:50
0:25
1:10
2:00
0:50
2:25
2:15
1:50
0:50
1:40
2:50
2:45
2:30
2:30
2:35
2:10
4:30
0:55
2:30
2:40
2:45
2:30