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:
Moderate

Other People Are Reading

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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