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

	G	H
68	Total Hrs. worked	9:00
69	Total min. Travel Time	1:00
70	Daily total	10:00

<TBODY>
</TBODY>

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)

	G	H
73	Grand total for the week	16:30

<TBODY>
</TBODY>

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.....