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
Click a cell where you want the decimal representation of the time difference to appear.

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

- 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."