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)

"LKWP" <(E-Mail Removed)> wrote in message
news:F6CF7FFF-F93F-4866-BB4D-(E-Mail Removed)...
>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??

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 <L...@discussions.microsoft.com> 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??