Calculating Elapsed Time Over a Set Period

  • Thread starter Thread starter JES
  • Start date Start date
J

JES

I have created a table which shows the amount of volunteer hours I have
worked each day. I then created another column which I wish to create a
running total of the hours worked each day. e.g:
A B C
1 Date Hours Running Total
2 01/09/09 03:30 03:30
3 02/09/09 03:30 07:00

However, when I get passed 24 hours, it goes back to 0 because the cells are
in time format. How can I create the running total to count the hours for
each day whilst overriding the 24 hour rule? Thank You in anticipation for
your help.
 
Format the Running Total formula cells as [h]:mm

The brackets [ ] keep the hours from rolling over after 24.
 
Back
Top