In this previous post, we have learned the simple and useful formula to convert the decimal hours into Excel time. Similarly, here we will show how to convert the decimal minutes into Excel time. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- If you want to convert minutes in decimal format to a proper Excel timing you can use the below formula.
=Minutes/1440
Syntax Explanations:
- MINUTE – In Excel, the Minute Function helps to return the Minutes as a number from 0 to 59 from the given time.
- Minute – It represents the input decimal minutes from your worksheet.
- Division (/) – It is used for dividing values or numbers.
Example:
Refer to the below example image.
- First, we will enter the input time in Column B.
- Here we are going to convert minutes in decimal format to a proper Excel time.
- So, apply the above-given formula to the formula bar section and press the ENTER key.
-
- Finally, we will get the result in the selected cell.
Bottom-Line:
Here, we have discussed the easy formula to convert the decimal minutes into Excel time. I hope this article is useful to you. Please feel free to state your query or feedback for the above article. Thank you so much for reading. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)