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