Excel: Convert Decimal Time to Hours & Minutes


You can use the following formula to convert a decimal time to hours and minutes in Excel:

=TEXT(B2/24, "h:mm")

This will convert the decimal time in cell B2 into hours and minutes.

For example, if the decimal time in cell B2 is 2.5 then this formula will convert it to 2:30.

The following example shows how to use this formula in practice.

Example: Convert Decimal Time to Hours & Minutes in Excel

Suppose we have the following dataset in Excel that shows the time (in decimal format) that it took for various athletes to finish some task:

To convert each decimal time to hours and minutes, we can type the following formula into cell C2:

=TEXT(B2/24, "h:mm")

We can then drag and fill this formula down to each remaining cell in column C:

Excel convert decimal time to hours and minutes

Notice that each decimal time in column B has been converted to hours and minutes in column C.

For example:

  • 2.5 hours is equal to 2 hours and 30 minutes.
  • 3.05 hours is equal to 3 hours and 3 minutes.
  • 4.25 hours is equal to 4 hours and 15 minutes.
  • 5.5 hours is equal to 5 hours and 30 minutes.

And so on.

Note: If you would also like to display seconds, you can use the following formula:

=TEXT(B2/24, "h:mm:ss")

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Convert Time Duration to Minutes
Excel: Calculate Difference Between Two Times in Minutes
Excel: Calculate Difference Between Two Times in Hours

One Reply to “Excel: Convert Decimal Time to Hours & Minutes”

  1. Thanks for that, however what if I already have a column populated with the exact times, but as numbers
    e.g. my column lists times in minutes (formatted as a number)
    41.12
    32.50
    35.12

    What I want to find out is the average time taken to complete these three tasks.
    If I use your method it will change the original values when it converts them from numbers to times (mm.ss), which will create new inaccurate times.
    How can this be done?

    My list currently comprises of over 600 times which I want to find the average of.

Leave a Reply

Your email address will not be published. Required fields are marked *