Excel is only letting me format a cell to show elapsed time in hours, mins,
secs, but not days. How do I do this?
Thanks,

Steve,

Simply subtract the earlier date from the later date, and format the cell as a number with as many
decimal places as you want. One day in Excel is 1, two days is 2, etc.

HTH,
Bernie
MS Excel MVP


"Steve M via OfficeKB.com" wrote in message ...
Excel is only letting me format a cell to show elapsed time in hours, mins,
secs, but not days. How do I do this?
Thanks,

Thanks, but I'm trying to get the format of the cell to be shown as [d]:hh:mm,
not a number with a decimal. When I enter this I get an error, but it works
for [h]:mm:ss. Why won't it work for days?

Thanks,

Bernie Deitrick wrote:
Steve,

Simply subtract the earlier date from the later date, and format the cell as a number with as many
decimal places as you want. One day in Excel is 1, two days is 2, etc.

HTH,
Bernie
MS Excel MVP

"Steve M via OfficeKB.com" wrote in message ...
Excel is only letting me format a cell to show elapsed time in hours, mins,
secs, but not days. How do I do this?
Thanks,


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