Sum formula does not provide the same outcome as AutoSum

[KuraiChikara]

Hello,
I have time formatted as hh:mm, when I highlight all of it, the AUTOSUM in the bottom right corner of Excel is correct. The total is 61:46 or 61 hours and 46 mins. However, when I try to use a formula to do the same outcome =SUM, the end result is 13:46, my time format in that cell is the same as the data it's adding (hh:mm) I have no idea where it's getting 13:46 and I can't seem to get my formula to calculate 61:46.

Data starting in A1-A14
08:00
08:00
08:00
02:45
08:00
01:19
00:19
07:05
04:24
02:20
02:30
08:00
00:54
00:10

 

[gaz_chops]

It is returning 2 days 13 hours 46 mins which = 61:46

[COLOR=#000000][FONT=-webkit-standard][TABLE="width: 87"]
<colgroup><col width="87" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="class: xl63, width: 87, align: right"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]02:45[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]01:19[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:19[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]07:05[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]04:24[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]02:20[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]02:30[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]08:00[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:54[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]00:10[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]02 13:46[/TD]
[/TR]
</tbody>[/TABLE]
[/FONT][/COLOR]

Change the format of the cell with the sum formula in, to be [h]:mm

 

[Scott T]

try formatting the cell

[h]:mm

 

[KuraiChikara]

Thank you! I forget how literal Excel can be (hh:mm) is just that, just the hours and the minutes so 13:46 is just reflecting the hours and minutes, not the days. Out of curiosity. Do you know the significance of the brackets around the hour [h] why would that reflect the full hour count and not simply h?

 

[Scott T]

That is how the excel formatting is setup.