You can just subtract and then use a custom format, then do whatever
calculations you want, the point is that the value you get is equal to 31
days 18 hours and 59 minutes, just do

=B1-A1

then custom format d tt:mm or d hh:mm whatever format you are using, I get
31 18:59 if I do that

--
Regards,

Peo Sjoblom

(No private emails please)


"MK" wrote in message
ups.com...
Thanks, but its not either days or hours Im after, but both :)

I need to work out a result that tells me how many days and hours there
are between the two times. I need to do further operations on the
result of the subtraction.