Time cell does not add correctly

[Brutium]

Good morning all,

I am trying to add the values in cell H73 (see below), but what I get is not correct.
In this cell H73, formatted as Time, I have this very simple formula:

=H14+H28+H42+H56+H70


[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD="align: center"][/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: right"]68[/TD]
[TD="align: right"]Total Hrs. worked[/TD]
[TD="align: right"]9:00[/TD]
[/TR]
[TR]
[TD="align: right"]69[/TD]
[TD="align: right"]Total min. Travel Time[/TD]
[TD="align: right"]1:00[/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]Daily total[/TD]
[TD="align: right"]10:00[/TD]
[/TR]
</TBODY>[/TABLE]








In cell H68 I have this formula: =Sum(A61:A67) (designated as Number),
in cell H69 I have =SUM(E62:E67)/60 (also designated as Number),
in cell H70, I have =SUM(H68:H69)/24 (designated as Time)



[TABLE="class: grid, width: 400, align: left"]
<TBODY>[TR]
[TD][/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: right"]73[/TD]
[TD]Grand total for the week[/TD]
[TD]16:30[/TD]
[/TR]
</TBODY>[/TABLE]





The value I get in H73 should add up to 41 hours and 30 minutes since daily totals are

H14 is 9:00
H28 is 7:30
H42 is 9:00
H56 is 5:00
H70 is 10:00

all of these are designated as Time.

Why is my "Total for the day" not adding correctly?

Any help would be greatly appreciated.

 

[VoG]

Format the result cell as Custom [h]:mm

 

[Andrew Poulsom]

For elapsed time format the cell as [hh]:mm.

 

[Brutium]

THANK YOU Andrew.

That worked great!!!!

Such a simple solution...

Good to know that there is always someone ready and willing to help.....