calculate the the diffrence between 2 Dates and time
 

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??

calculate the the diffrence between 2 Dates and time
 

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)

"LKWP" wrote in message
...
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??

calculate the the diffrence between 2 Dates and time
 

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

On Jul 2, 1:18*pm, LKWP wrote:
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??