View Single Post
  #1   Report Post  
Charles Watson
 
Posts: n/a
Default Adding Days:Hours:Minutes

I have to calculate how long (in day:hours:mins) a certain vehicle is spent
on different processes. Every quarter I then have to produce a report
showing the total time on each process, for example on stand-by. If month 1
it is 17:04:30, Month 2 15:07:30 and month 3 12:08:20 I would expect the
total to be 44:20:20 (44 days, 20 hours and 20 mins). With the cells
formatted to dd:hh:mm a value of 14:20:20 is shown - that is the days seem
to start counting again after 30 is reached. How do I get around this
problem?

Thanks in advance.

Charles