Excel stores time as a decimal; only format it as a time. With the help of formulas, you can convert that time into decimals; still, those decimals make sense to the user.
Time into Decimals (Hours – Minutes – Seconds)
- Enter (=) in a cell
- Refer to the cell where you have the time.
- Type an asterisk (*).
- Enter (24) and hit enter to get the result.
The cell where you enter this formula must have the cell format “Number” with two decimals.
- Whole Hours: =INT(A1*24)
- Minutes: =A1*1440
- Seconds: =A1*86400
Remove Format to Get the Decimal for a Time
- Select the cell.
- Open the Format Cell Option.
- Click General.
- Click OK to Save.
When you click OK, it converts that value into a decimal value.