# How to Convert Excel Time Difference to Decimal Number

Written by stephanie ellen
• Share
• Tweet
• Share
• Pin
• Email

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

## 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

#### References

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

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