How to convert decimal hours/minutes to time format in Excel?

In some cases, you may record time as decimal hours or minutes such as this 31.23, how can you convert this decimal hours or decimal minutes to standard time format hh:mm:ss as below screenshot shown. In this article, I introduce some tricks for you to quickly finish this conversion in Excel.

Convert decimal hours/minutes to time format with formulas

Convert time to decimal hours/minutes/seconds

Convert decimal hours/minutes to time format with formulas

Here are some simple formulas which can help you to quickly convert decimal hours or decimal minutes to hh:mm:ss.

1. Select a blank cell which you want to output the converted result, and enter this formula =A2/24, drag fill handle over the cells you need. See screenshot:

2. Keep the formula cells highlighted, and right click to show context menu and select Format Cells. And in the Format Cells dialog, select Time from the Category list, and choose one time type as you need from right section. See screenshot:

3. Click OK. Now the decimal hours have been converted to time format.

Note: if you want to convert decimal minutes to time format, you can apply this formula =A2/1440, and then format the cells as the time format you want. If you want to convet seconds to time, use this formula =A2/86400. See screenshot:

Convert time to decimal hours/minutes/seconds

If you want to convert time in format hh:mm:ss to decimal hours, minutes or seconds, the Convert Time utility of Kutools for Excel to quickly solve this job.

After installing Kutools for Excel, please do as below:

Select the time cells you want to convert, click Kutools > Content > Convert Time > Time to Hours/Time to Minutes/Time to Seconds.

If you want to save the converted result in another location, click Kutools > Content > Convert Time > Convert Time, then in the popping dialog, check the operation as you need, and select one cell to place the result.