Assume that you have a list of time cells that indicate the worked hours and specify the rate per hour, now you have to calculate the payment based on hours and rate. How could you solve them in Excel? In this article, I will introduce the formula for you to convert time into money in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- You can use the below formula to convert time into money in Excel.
=(time*24)*rate
Syntax Explanations:
- Time – It represents the input time from your worksheet.
- Rate – It specifies the rate per hour.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- *Multiplication (*) *– In this symbol will multiply any two values or numbers.
Practical Example:
Refer to the below example image.
- First, we will enter the input time in Column B.
- Now we are going to calculate the amount based on the criteria in Column C.
- 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.
Wrap-Up:
From this short article, you can get to know how to convert time into money in Excel. I hope you like this article!! If you have any doubts, feel free to let me know. I reply to queries frequently. Thank you so much for visiting our site. Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)