Time Format

[Lee]

I'm having a problem adding together journey times.

I have a start time (say 8:34:00) and an end time (say 10:23:00) and from
this I calculate a journey time (1:49:00). I then add this journey time
(using the sum function) across a number of different journeys giving me a
total. This total is in some case in excess of 24 hours and Excel seems to
revert to 0 at 24 hours and start the sum again. So for example I can see
when I highlight the range that the total is 27:49:00 but the sum function
returns 03:49:00.

Any ideas?

Cheers

Lee

 

[Dave Peterson]

Use a custom format:
[hh]:mm:ss

The []'s keep that rollover from happening.