Multiply Hours by Money in Excel: A Practical Guide

To calculate pay from decimal hours, put the hours in B2 and the hourly rate in C2, then enter =B2*C2 in D2; for 7.5 hours at $22.50 per hour, the result is $168.75. If your hours are entered as clock time, such as 7:30, convert Excel’s time value to hours by multiplying by 24 before multiplying by the rate. The steps below show both methods and how to format and check the result.

This calculation is useful for timesheets, contractor invoices, project costing, and simple labor estimates. The key is to know whether your hours are decimal numbers (7.5) or Excel time values (7:30). Those two entries look similar in meaning but need different formulas.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The same basic formulas work in Excel for Mac and Excel for the web, though ribbon layouts can vary slightly.
A column for hours and a cell or column for the hourly rate. Use a consistent unit and make sure the rate is a number, not text.
A small sample row you can check by hand, such as 7.5 hours at $22.50 per hour.

Step-by-Step

Set up clear column headings. In a blank worksheet, enter headings such as Employee, Hours, Hourly Rate, and Amount. For a quick calculation, you can use B1 for Hours, C1 for Hourly Rate, and D1 for Amount. A clear layout makes it easier to copy the formula and identify whether a value represents hours or dollars.
Enter hours as a decimal if possible. Type 7.5 to represent seven and a half hours, or 8 to represent eight hours. Do not type 7:30 if you intend the value to mean decimal hours; Excel interprets that entry as a time of day or duration and stores it as a fraction of a 24-hour day. Decimal hours are often the simplest format for multiplying by a rate.
Enter the hourly rate as a number. Type 22.5 or 22.50 in the rate cell. You can apply currency formatting afterward. Avoid typing words such as “per hour” in the cell, because text cannot be multiplied as a number. If the rate is the same for every row, enter it once and copy it down, or refer to a single rate cell in each row.
Multiply decimal hours by the rate. With decimal hours in B2 and the hourly rate in C2, put this formula in D2: =B2*C2. For 7.5 hours and a rate of $22.50, Excel returns 168.75 because 7.5 × 22.50 = 168.75. The formula uses cell references, so changing either input updates the amount automatically.
Format the result as currency. Select D2, or the full Amount column, and choose Home > Number group > Accounting Number Format or the Currency option from the number-format dropdown. Choose the appropriate currency symbol if prompted. Formatting changes how the result appears; it does not change the underlying multiplication. You can also use the number format controls on the Home tab to show two decimal places.
Copy the formula down for more rows. Select D2 and drag the small fill handle at the lower-right corner of the cell down the column, or copy D2 and paste it into the remaining amount cells. With decimal hours in column B and hourly rates in column C, the copied formula adjusts to each row, such as B3 times C3. Check the first and last copied rows to make sure the references match the intended hours and rate.
Use a conversion if your hours are entered as time. Excel stores a time such as 7:30 as 7.5 hours divided by 24. With a duration of 7:30 in B2 and an hourly rate of $22.50 in C2, enter =B2*24*C2 in D2. The result is $168.75: 7:30 represents 7.5 hours, and 7.5 × $22.50 = $168.75. Format D2 as currency, not as time.
Format the time entry so it is easy to read. If B2 contains a duration, select the hours cells and choose Home > Number group > Number Format dialog launcher, then select a time format. For durations that may exceed 24 hours, use a custom format such as [h]:mm so the total hours keep accumulating instead of displaying as a time that wraps after 24. In Excel for Windows, Ctrl+1 opens the Format Cells dialog; on Mac, use Command+1.
Calculate a duration from start and finish times when needed. Suppose B2 contains a start time of 9:00, C2 contains an end time of 16:30 on the same day, and D2 contains the hourly rate of $22.50. In E2, enter =(C2-B2)*24*D2. Excel returns 168.75, since the elapsed time is 7.5 hours. Format E2 as currency. This simple version assumes the shift ends on the same day and does not account for unpaid breaks.
Add up the individual amounts. With calculated pay amounts in D2:D10, enter =SUM(D2:D10) in D11. If the nine rows total $1,500.00, D11 displays $1,500.00 when formatted as currency. Make sure the sum range covers all the rows you want included and does not accidentally include a previous total.

For a basic worksheet, use one row per person, shift, or task. If the rate changes between rows, enter the correct rate beside each hours entry rather than relying on a single rate. If you need a grand total for a longer list, you can extend the SUM range or use an Excel Table so new rows are easier to include.

Common Mistakes

Multiplying a time value without converting it. If B2 contains 7:30 and C2 contains 22.50, =B2*C2 treats B2 as a fraction of a day. The result is only 7.03125, not $168.75. Use =B2*24*C2 for a duration stored as time.
Mixing decimal hours and clock-style hours. 7.30 as a decimal means 7.3 hours, or 7 hours and 18 minutes—not 7 hours and 30 minutes. Enter 7:30 as a time value and multiply by 24, or enter 7.5 as decimal hours and multiply directly.
Typing the currency symbol into a text value. A cell containing text such as “$22.50 per hour” may not work in a calculation. Enter a numeric value and apply a currency format through Excel’s number formatting tools.
Formatting the amount as a time. If a pay formula appears as a date or clock time, the calculation may be fine but the result cell has the wrong number format. Set the result to Currency, Accounting, or Number.
Using the wrong rate or range. When filling formulas down, verify that each row uses its own hours and rate. When totaling, make sure the SUM range includes every amount once and excludes headings or an existing total.

Tips

Keep input cells separate from formula cells. For example, use B for hours, C for rates, and D for calculated amounts. This reduces the risk of overwriting a formula while editing a timesheet.
Choose one hours convention for the whole sheet. Decimal hours are convenient for direct multiplication; time entries are useful when staff record start and end times. Label the column clearly as “Hours (decimal)” or “Duration (h:mm).”
For payroll or billing, decide how to handle rounding before building the sheet. Excel can display two decimals while retaining more precision underneath. If you need each row rounded to cents before totaling, do so deliberately and check that this matches your required process.
Protect important formulas from accidental edits by keeping them in a dedicated column and using clear headings. You can also apply a distinct fill color to input cells, but document what the color means.
Use a test row with easy arithmetic before entering a full set of data. For example, 2 hours at $10 per hour should produce $20. A quick hand check can reveal a missing factor of 24 or a misplaced cell reference.
For overnight shifts, be careful with start and end times. A simple end-minus-start calculation can produce a negative duration when the end time is after midnight. Enter full date-and-time values or use a formula designed for overnight shifts, and account for breaks separately.

Troubleshooting

The result is much smaller than expected: Check whether the hours cell contains a time such as 7:30 rather than the decimal number 7.5. If it is a time value, use the conversion formula with ×24. Also inspect the formula bar to see the stored value and confirm that the rate is in the cell referenced by the formula.

The formula displays literally instead of calculating: The cell may be formatted as Text, or the entry may begin with an apostrophe. Change the cell format to General, select the cell, press F2, and then press Enter to re-enter the formula. Check that the formula begins with an equals sign and that Show Formulas is not turned on. In Excel for Windows, Ctrl+` toggles formula display; on Mac, the equivalent shortcut can vary by keyboard, and the Show Formulas command is available on the Formulas tab.

You see ###### in the result: The column may be too narrow for the formatted value. Widen the column by dragging its right boundary or double-clicking that boundary to AutoFit. If the cells contain time values, a negative time result can also show as hash marks under the default date system; verify the time calculation and cell format.

The total is wrong or does not change: Check that the total formula covers the intended rows and that the cells contain numbers rather than text. If automatic calculation is disabled, go to Formulas > Calculation Options > Automatic. Also look for a total included inside its own SUM range, which can create a circular reference.

An overnight shift gives a negative amount: A formula that subtracts a later start time from an earlier end time assumes both occur on the same day. Record the date as well as the time for each timestamp, or use a calculation that explicitly handles shifts crossing midnight. Then verify that any break deduction is applied in hours before multiplying by the rate.

Frequently Asked Questions

How do I multiply 8 hours by $20 in Excel?
Enter 8 as a number in one cell and 20 in another, then multiply the cells. With hours in B2 and rate in C2, use =B2*C2; the result is 160, which you can format as $160.00.

Why do I need to multiply time by 24?
Excel stores time as a fraction of one day. A duration of 12 hours is stored as 0.5, for example. Multiplying a time value by 24 converts it to the number of hours before you apply an hourly rate.

Should I enter 7.5 hours or 7:30?
Either can work if you use the matching method. Enter 7.5 and multiply directly by the rate, or enter 7:30 as a duration and multiply the time cell by 24 and by the rate. Do not treat 7.30 as 7 hours and 30 minutes.

How can I include a lunch break?
Subtract the unpaid break from the shift duration before multiplying by the rate. For example, record the break in hours as a separate value and subtract it from total hours, or use start, end, and break columns. Confirm whether the break is paid or unpaid under the applicable work arrangement; the basic Excel formula cannot determine that policy.

Does Excel automatically calculate overtime?
No. The multiplication formula applies the rate you provide; it does not identify overtime rules or apply a different rate automatically. If you need separate regular and overtime amounts, calculate those hours in separate columns using the applicable rules and rates.

Can I use this in Excel for Mac or the web?
Yes. Multiplication, time values, and currency formatting work in Excel for Mac and Excel for the web as well. The ribbon arrangement and keyboard shortcuts may differ, but the formulas shown here are the same.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.