How to Convert Decimal Time to Hours and Minutes in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

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.

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

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.

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

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

Read More: How to Convert Time to Decimal in Excel

2. Converting 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.

• 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 Time to Hours in Excel

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.

Related Articles

<< Go Back to Convert Time to Hours | Time Conversion | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF