Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Convert Decimal Time to Hours and Minutes in Excel

The vital feature of decimals, the time concept is the standard which used split time is like the standard used to express it. The entire time expression may be managed as a single string. As a result, interpreting a timestamp and performing conversions becomes easier. At the present, it is doubtful that decimal time will become widely used. But while working with the decimal time format, we need to convert them for better understanding. In this article, we will demonstrate the effective methods to convert decimal time to hours and minutes in Excel.


Download Practice Workbook

You can download the workbook and practice with them.


2 Effective Methods to Convert Decimal Time to Hours and Minutes in Excel

Everyone understands that there are 24 hours in a day. That’s the reason we will divide the decimal time by 24 to get the hours and minutes. Suppose we have a dataset that contains some employee names and their total working time for a week. But the time is in decimal time format, now we need to convert the decimal time to hours and minutes.

2 Effective Methods to Convert Decimal Time to Hours and Minutes in Excel


1. Convert Decimal Time to Hours and Minutes Using TEXT Function

The Excel TEXT Function is being used to transform integers into text. This function produces a number as text with the formatting specified. To include formatted numerals in text, use the TEXT function. We can also convert decimal time to hours and minutes using this function. For this, we need to follow the procedures down.

STEPS:

  • In the first place, choose the cell where you want to put the formula for converting the decimal time to hours and minutes.
  • Then, enter the following formula there.
=TEXT(C5/24,"h:mm")
  • After that, to complete the operation hit the Enter key.

3698_38-0096_AYON_convert decimal time to hours and minutes in excel

  • Furthermore, to copy the formula over the range, drag the Fill Handle down or double-click on the Plus (+) icon.

3698_38-0096_AYON_convert decimal time to hours and minutes in excel

  • And, finally, that’s it! You will get the hours and minutes in column D.

Read More: How to Convert Decimal to Time Over 24 Hours in Excel (2 Quick Methods)


Similar Readings


2. Convert Decimal Time to Hours and Minutes with Simple Excel Formula

In the spreadsheet, we may write a basic formula to add, subtract, multiply, or divide data. Simple formulae generally begin with an equal sign (=), surrounded by numerical parameters and computation operations. A formula in Microsoft Excel is a statement that works on values in a range of cells. To convert decimal time to hours and minutes we need to follow the process below.

STEPS:

  • Firstly, select cell D5 and substitute the formula.
=C5/24
  • Then, press Enter. And the formula will show in the formula bar.

  • Further, to replicate the formula throughout the range, drag the Fill Handle downward. To AutoFill the range, double-click on the Plus (+) symbol.

  • By doing this you will get the result. But if you want a more specific result, you have to follow it further.

  • Further, select the resulting cells, then go to the Home tab of the ribbon.
  • Next, under the Number category, click on the tiny icon shown below.

3698_38-0096_AYON_convert decimal time to hours and minutes in excel

  • This will open the Format Cells dialog box.
  • Now, go to the Number menu and select Custom from the category.
  • And, in the Type menu, select h:mm.
  • After that, click on the OK button to complete the procedures.

  • And, finally, this is it! You will get the result.

Read More: How to Convert Decimal to Days Hours and Minutes in Excel (3 Methods)


Conclusion

The above methods will assist you to Convert Decimal Time to Hours and Minutes in Excel. Hope this will help you! If you have any questions, suggestions, or feedback, please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo