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:
Other People Are Reading
Click a cell where you want the decimal representation of the time difference to appear.
Type "= A1 * 24" and then press "Enter."
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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for