How to Convert Excel Time Difference to Decimal Number

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert Excel Time Difference to Decimal Number
Time differences can be used to calculate how many hours have elapsed since an event. (Ryan McVay/Photodisc/Getty Images)

Excel can display time differences in a variety of ways, including decimal format and time format. For example, if you have a time difference in a cell of 8 hours and 15 minutes, you can display that time as 8:15 or 8.25 because 15 minutes is a quarter, or 25 per cent, of an hour. You can use a simple formula to display a time difference in decimal format.

Skill level:


  1. 1

    Click a cell where you want the decimal representation of the time difference to appear.

  2. 2

    Type "= A1 * 24" and then press "Enter."

  3. 3

    Change the cell location "A1" to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type "C3" into the formula instead of "A1." Pressing "Enter" for this result will give you the decimal result "1.25."

Tips and warnings

  • If you get an unexpected result, make sure you have formatted the cell for decimals. To format a cell for decimals, right click the cell and then click the "Number" tab. Click "Number" from the Category list and then click "OK."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.