Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help neede with adding times | Excel Discussion (Misc queries) | |||
how do I combine workbooks, adding new text | Excel Discussion (Misc queries) | |||
problem adding | Excel Discussion (Misc queries) | |||
Adding an apostrophe | Excel Discussion (Misc queries) | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |