Ron,

Actually, no. That will round the days up incorrectly when the hours are more than 12.

HTH,
Bernie
MS Excel MVP


"Ron Rosenfeld" wrote in message
...
On Mon, 08 Aug 2005 14:58:58 GMT, "Steve M via OfficeKB.com"
wrote:

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?


0":00:00"


--ron