V
vrk1
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(D134) 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?
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(D134) 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?