Adding TIME

[Mike Coleman]

I am tracking a 5 day sporting event that has stages and
legs within the stage.
I am estimating the time it will take to complete a leg,a
stage and a cumulative time. I input the leg time, have
excel calculate the stage time and the cumulative time.
My problem is when a day rolls over ( 24 hours have
elapsed since the start).
The cumulative result goes back to 0:00 and starts from
scratch.
How can I have the cumulative time accuratly show the
a/ actual elapsed time or
b/ the day and lapsed time for that day.
cheers
Mike

 

[Norman Harker]

Hi Mike!

Format the total:

[hh]:mm:ss

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.