Steve,

There is no format that will do that. You could use a formula:

=INT(A2-A1)& ":" &TEXT(A2-A1,"hh:mm")

but Excel will interpret the result as hh:mm:ss if you try to do further math using it.

HTH,
Bernie
MS Excel MVP


"Steve M via OfficeKB.com" wrote in message ...
Cell A1 is Jan 1, 2005 0:00
Cell A2 is Feb 28, 2005 00:00

I want cell A3 to calculate the elapsed time in days shown as "58:00:00".
How do I format cell A3?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1