View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pontoon
 
Posts: n/a
Default I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps

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.