Format elapsed time in days?

  • Thread starter Steve M via OfficeKB.com
  • Start date
S

Steve M via OfficeKB.com

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,
 
B

Bernie Deitrick

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
 
S

Steve M via OfficeKB.com

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,
 
Top