Convert Time to Decimals

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)

1. Enter (=) in a cell
2. Refer to the cell where you have the time.
3. Type an asterisk (*).
4. 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.

And for:

1. Whole Hours: =INT(A1*24)
2. Minutes: =A1*1440
3. Seconds: =A1*86400

Remove Format to Get the Decimal for a Time

1. Select the cell.
2. Open the Format Cell Option.
3. Click General.
4. Click OK to Save.

When you click OK, it converts that value into a decimal value.

http://excelchamps.com/wp-content/uploads/2023/02/time-to-decimals.xlsx