Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get the total time that it took from the date and time
something was inducted until the date and time it was completed. I have seen a few suggestions that come close, but not exactly correct. I.E. cell A1 = 01/30/2006 23:45 cell B1 = 02/02/2006 07:00 cell C1 input the formula =B1-A1 and change the format to M:DD:HH:MM But this usually comes back with a figure like 1:02:07:15, which to me is wrong as it is stating 1 month, 2 days, 7 hours and 15 minutes. Everything is okay except for the month, which should be zero, as it really only took 2 days, 7 hours and 15 minutes. If I do the same but change the second data to 05/22/2006 07:00 then I get a figure of 4:20:07:15. This again appears wrong to me. It should only be 3 months (FEB, MAR, APR), 21 days, 7 hours 15 minutes. Any advice is welcomed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
getting a total for a row of cells where some are text | Excel Discussion (Misc queries) | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |