Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to work out the number of years, months, days AND the elapsed time
between two timestamps. I can compare dates OR Times, but not both together. If I do a simple subtract ( A1-A2 ) with the results in A3 formatted using the custom format yy" Years" mm" Months" dd" Days" hh" Hours" mm" Minutes" ss" seconds" it almost works - HOWEVER Excel seems to add a spurious month to the results. (It seems to also do this even if I enter a zero into a cell, then format it using the same custom format! ) I must be doing something stupid, so any help would be more than welcome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum time in hh:mm:ss format | Excel Discussion (Misc queries) | |||
Negative time value hh:mm:ss | Excel Discussion (Misc queries) | |||
Time for some help (Please!) | Excel Worksheet Functions | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions |