As long as the difference is less than 32 days you could just subtract one
from the other, and use a format of "d h:mm:ss" (without the quotes)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Michell Major" wrote in message
...
Bob. How about ... Date and time subtracted from each other to give
aDay,Hour and Minute return?

Regards

Dan

"Bob Phillips" wrote:

=Y5-A2-TIME(0,30,0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wnfisba" wrote in message
...
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the
current
time. Is there any way I can take another 30 minutes off of this
calculation???

Y2-A2-????