Format elapsed time in days?

  • Thread starter Thread starter Steve M via OfficeKB.com
  • Start date 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,
 
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
 
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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for elapsed time 3
Calculate elapsed time excluding specific timeframe 10
Cumulative time calculation in Excel 2003 2
Elapsed Time Formula 6
Calculating Elapsed Time 2
Formatting cells to show elapsed time 6
Calculate Ending time using Start Time and Elapsed Time 5
Time elapsed calculation 6

Back
Top