Finding an hourly rate can help you in many ways for a business or other purposes. There are many ways to do it but this article will provide you with two smart and quick ways to calculate the hourly rate in Excel with sharp steps and vivid illustrations.

**Calculate Hourly Rate in Excel: ****2 Ways**

To explore the methods weâ€™ll use the following dataset which represents the daily paid amount of the writers of a content publishing site named â€˜**ExcelDemy**â€™.

**1. Manual Formula to Calculate Hourly Rate in Excel**

Now to calculate the hourly paid rate, weâ€™ll use a manual formula in the first method. The formula is so simple, just divide the amount by hours. But keep in mind that, you will have to multiply the hours by 24. Because Excel stores the time as a fraction of a day. So 5:00 is defined by the system as 5/24 which is 0.21. So by multiplying that time by 24, you will get 5. Now letâ€™s start.

- Activate
**Cell E5**. - Then
**write**the following**formula**in it-

`=D5/(C5*24)`

- Later, just
**press**the**Enter**button to get the**result**.

- After that,
**drag down**the**Fill Handle**icon to copy the formula for the other cells**E6:E11**.

Then you will get all the writersâ€™ hourly rates.

**2. Use QUOTIENT Function to Calculate Hourly Rate in Excel**

As we need to divide values for finding hourly rate, we can use **the QUOTIENT function** to do that. Because the **QUOTIENT **function is used to return the integer value of a division.

**Type**the following**formula**in**Cell E5**â€“

`=QUOTIENT(D5,(C5*24))`

**Hit**the**Enter**button to get the output.

- Now to get all the other hourly rates, drag down the
**Fill Handle**icon over the cells**E6:E11.**

Then soon after you will get all the other hourly rates as integer values.

**How to Calculate Payment with a Formula Using the Hourly Rate in Excel**

If the hourly rate is given then we can easily find the total payment for a specific time by multiplying the rate and time. Letâ€™s learn that in this section. For that, I have modified the dataset by replacing the â€˜**Paidâ€™ **column with â€˜**Rateâ€™**.

- In
**Cell E5**write the following**formula**â€“

`=(C5*24)*D5`

**Hit**the**Enter**

- Finally, just
**drag down**the**Fill Handle**icon to finish.

Soon after you will get all the payments for the writers.

**Things to Remember**

- Donâ€™t forget to multiply the time by 24.
- The
**QUOTIENT**function will give you only the integer portion of a division. So if you want the exact values, try the first method.

**Download Practice Workbook**

You can download the free Excel template from here and practice on your own.

**Conclusion**

I hope the procedures described above will be good enough to calculate the hourly rate in Excel. Feel free to ask any question in the comment section and please give me feedback.

I’m computer illiterate so I want to know more on excel 2013

Hello JEMAIMAH OMAKEN, thanks for your feedback.

Visit our site to explore more articles that will work on Excel 2013. As 2013 is not so older version so you will find no major differences.