So far we have learned how to convert decimal hours, minutes, seconds into a valid Excel time format. Now in this article, we are going to see how to convert a time into decimal hours in Excel. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To convert time to a number of hours, multiply the time by 24 , which is the number of hours in a day. The formula is:
=A1*24
Syntax Explanations:
- A1 – It represents the input time on your worksheet.
- *Multiplication (*) *– In this symbol will multiply any two values or numbers.
Practical Example:
Let’s consider the below example image.
- Here we have a list of times in Column B.
- Now we need to convert them into decimal hours.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
- If the result of your formula is not displayed as a decimal, you need to change the cell formatting.
Verdict:
In this article, you can get to know how to convert a time into decimal hours in Excel. I hope you enjoyed the blog post. If you have any issue regarding this article or any unresolved query , please comment in the comment box below. We will assist you.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)