calculate the the diffrence between 2 Dates and time

  • Thread starter Thread starter LKWP
  • Start date Start date
L

LKWP

I am trying to create a formula that calculates the diffrence beween the date
and the time. I.e result would be 3d 10m ot 3d 10m30s. Can anyone help??
 
How about

=INT(A7-A6)&"d "&TEXT(MOD((A7-A6),1),"h:mm:ss")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Are your date/time values combined in one cell, or separate cells for
date and for time?

Essentially, you just need to subtract the smaller (earlier) date/time
from the larger (later) date/time, and then apply a custom format to
the result as you require it, but you will need to account for hours
as well as minutes and seconds.

Hope this helps.

Pete
 
Back
Top