Harold - You were spot on the issue. One of the cells was not in this format
and this was causing the issue. Many thanks to everyone that volunteered
their time and expertise for me.

Much appreciated!

"Harald Staff" wrote:

Format ALL your time cells as [hh]:mm, not only the grand total, and you
will hopefully spot the problem.

HTH. Best wishes Harald

"vrk1" wrote in message
...
Hi,

I have the following info in an excel spreadsheet:

Starttime EndTime Hours SubTotal
8:00 am 9:00 am 1:00
12:30 pm 2:30 pm 2:00
3:00


I am adding all the cells in the Subtotal Column and my grand total is
24
hours...something like 27:30. I used the formula =sum(D1:D34) on the
Grand
total field on Column D and formatted the cell as [hh]:m following the
advice
in this discussion forum.

My total is still not coming to 27:30. It shows up as 314:30. What am I
doing wrong? Can someone help me please?