How to Multiply Hours by Rate in Excel and Format Totals

For decimal hours, put the hours in B2 and the hourly rate in C2, then enter =B2*C2 in D2 to calculate pay. If the hours are entered as an Excel time such as 7:30, use =B2*24*C2 instead. Format the result as currency so it is easy to read. The key is to know whether your hours are decimal numbers or time values.

What You’ll Need

A worksheet with a column for hours and a column for the hourly rate. Add a third column for the calculated amount.
Hours recorded consistently: for example, decimal hours such as 7.5, or elapsed time such as 7:30.
An hourly rate entered as a number, such as 20 or 20.50. You can apply currency formatting afterward; avoid storing the rate as text.
Microsoft Excel for Microsoft 365 on Windows. The same basic formulas work in Excel for Mac and Excel for the web, although ribbon layouts can differ slightly.

Step-by-Step

Set up clear column headings. In a blank worksheet, enter Hours in A1, Hourly Rate in B1, and Pay in C1. The exact columns do not matter, but headings help you keep the formula references straight. If you are calculating several shifts or employees, put one record on each row. For example, a row might represent one employee’s shift, with that shift’s hours and applicable rate beside it.
Enter the hours in one consistent format. For decimal hours, type a number such as 7.5 to mean seven and a half hours. Do not type 7:30 and assume Excel will interpret it as 7.5; Excel usually reads that entry as a time value. If your source data uses hours and minutes, you can enter a time such as 7:30 instead, but use the time-value method in step 4. Check that the cells are not text: a number stored as text may align left or display a warning marker.
Enter the hourly rate as a number. Type a numeric rate such as 20 in B2. You may type a currency symbol if Excel recognizes the entry as a number, but the reliable approach is to enter the number and apply a currency format afterward. If rates vary by shift, enter the correct rate in each row rather than assuming one rate applies to all records. Keep the rate unit consistent: this method expects a rate per hour.
Multiply decimal hours by the rate. With decimal hours in A2 and the hourly rate in B2, enter this formula in C2: =A2*B2. For example, if A2 contains 7.5 and B2 contains 20, C2 returns 150. The calculation is 7.5 hours × 20 currency units per hour = 150 currency units. The formula uses ordinary multiplication, represented by the asterisk. You do not need a special hours or payroll function for this basic calculation.
Use the correct formula for time entries. Excel stores a time as a fraction of a 24-hour day. A value displayed as 7:30 represents 7.5 hours, but its stored value is 7.5 divided by 24. Therefore, with an elapsed-time value in A2 and the hourly rate in B2, enter =A2*24*B2 in C2. If A2 displays 7:30 and B2 contains 20, this formula returns 150. Without the multiplication by 24, the result would be only 6.25, because Excel would multiply the rate by 0.3125 days rather than by 7.5 hours.
Format the pay result as currency. Select the result cell or the whole Pay column. On Windows, choose Home > Number group > Currency. You can also select Accounting if you prefer currency symbols aligned down the column. Use the decimal-place controls in the Number group if you need a particular number of decimal places. Formatting changes how the value is displayed, not the calculation itself, so C2 remains a numeric result that Excel can total.
Copy the formula down the column. Select C2 and drag the small fill handle at the lower-right corner of the selected cell down through the rows you need. You can also copy C2, select the destination cells, and paste. Excel adjusts the relative references automatically: the next row will use A3 and B3, then A4 and B4, and so on. After filling, spot-check a few rows to confirm each result refers to hours and rate from the same row.
Check the calculation with a small example. For decimal hours, enter 8 in A2 and 25 in B2; the formula in C2 returns 200. For a time-value check, enter 8:00 in A2, 25 in B2, and use the time-value formula; it also returns 200. Comparing a simple result by hand is a quick way to catch a wrong cell reference or a missing multiplication by 24 before you calculate a longer list.

Common Mistakes

Multiplying a time value directly by the rate. If A2 contains 7:30 as a time value, =A2*B2 does not treat it as 7.5 hours. It treats it as a fraction of a day. Include the conversion factor of 24 as shown above.
Using the time formula on decimal hours. If A2 contains 7.5 as a decimal number, adding the factor 24 would calculate 180 hours’ worth of rate rather than 7.5. Match the formula to the way the hours are stored.
Formatting pay as time. A result displayed like a clock time may be a formatting issue, not a bad multiplication. Select the pay cells and choose Currency or Number rather than a Time format.
Entering a rate as text. A pasted value with an apostrophe, an unexpected space, or a text-only currency symbol may not behave as a number. Re-enter the rate as a numeric value and apply currency formatting to the cell.
Mixing different kinds of hours. Decimal hours such as 7.5 and time values such as 7:30 can look like equivalent entries but require different formulas. Standardize the source data where practical, or use a clearly labeled column and formula for each type.
Assuming this calculates overtime. These formulas multiply all entered hours by one rate. They do not apply overtime premiums, breaks, shift differentials, or other pay rules. If those affect the result, calculate the relevant hours and rates separately according to the applicable policy.

Tips

Label the hours column as either Decimal Hours or Elapsed Time. This makes the expected entry and formula clear to anyone who opens the workbook later.
Keep the original hours and rate in separate columns and put the calculation in its own column. This makes the result easier to review and lets you change an input without replacing the formula.
For shifts longer than 24 hours or accumulated durations, use an elapsed-time number format such as [h]:mm on the duration cells. Ordinary time formats can wrap after 24 hours and make a long total appear smaller than it is. This display format does not change the need to multiply a time value by 24 when calculating hourly pay.
Use consistent decimal places for rates and amounts. For example, display money with two decimal places, but keep the underlying values unrounded unless you have a specific rounding requirement.
If your entries are decimal hours, consider showing one or two decimal places in the hours column so values such as 7.5 are easy to distinguish from 7:30. Use the cell’s number format rather than changing the underlying value.
When copying a formula, keep the input columns and result column clearly separated. Avoid typing over a calculated cell with a fixed amount, because that removes the formula and can make later updates inconsistent.

Troubleshooting

The result looks far too small. First check whether the hours cell is a time value displayed with a colon. If it is, confirm that the formula includes multiplication by 24. For example, 7:30 is stored as 0.3125 of a day; multiplying that directly by 20 gives 6.25, while converting to hours first gives 150.

The result looks like a time or date. Select the result cells and choose Home > Number group > Currency or Number. Excel can retain a Time or Date format from a copied cell even when the formula returns a correct numeric amount. If the displayed value changes after selecting Currency, the underlying calculation may already have been correct.

The formula appears in the cell instead of a result. Make sure the entry begins with an equals sign and that the cell is not formatted as Text. Change the cell format to General, then edit the formula and press Enter. Also check that Show Formulas is not enabled; press Ctrl+` on Windows to toggle it. On Mac, the equivalent shortcut can vary with the keyboard layout; use Formulas > Show Formulas if available in your ribbon.

You see a warning or an unexpected zero. Check that both inputs are numeric and that the formula points to the intended cells. In Excel, a value pasted as text may not multiply as expected. Re-enter the value or use the cell warning options to convert a number stored as text. Also verify that a blank or zero rate has not been copied into the row.

Copied rows show the same answer. Click a few result cells and inspect the formula bar. The row references should change as the formula is filled down. If they do not, the formula may contain fixed references with dollar signs, or the formula may have been pasted as a value. Edit the first formula to refer to the matching row, then fill it down again.

Frequently Asked Questions

What is the formula to multiply hours by an hourly rate?
For decimal hours, multiply the hours cell by the rate cell, such as =A2*B2 when A2 contains hours and B2 contains the hourly rate. If the hours are Excel time values such as 7:30, use =A2*24*B2.

How do I enter 7 hours and 30 minutes?
You can enter 7.5 as decimal hours, or enter 7:30 as an Excel time value. Use the decimal-hours formula for 7.5 and the formula with a factor of 24 for 7:30. Do not switch between these entry styles without also using the matching formula.

Why does Excel show 0.31 instead of 7.5 hours?
Excel stores times as fractions of a day, so 7:30 is stored as 0.3125. That is the underlying value, not a decimal-hours total. Multiply the time value by 24 to convert it to hours for the pay calculation.

Can I multiply a total number of hours by one rate?
Yes. If the total is a decimal number, multiply that total by the rate. If the total is an Excel duration, multiply it by 24 and then by the rate. For multiple rows, calculate each row consistently and add the resulting pay amounts, especially if different rows have different rates.

How do I show two decimal places in the result?
Select the result cells and choose Home > Number group > Currency, then set two decimal places with the increase or decrease decimal controls if needed. This changes the display. It does not automatically round the underlying calculation to two decimal places.

Does this formula include overtime or unpaid breaks?
No. It calculates hours multiplied by the stated rate. Enter the payable hours and rate you intend to use, and calculate any separate overtime or adjustments in additional columns. The basic multiplication formula does not decide which hours are payable or what rate applies.

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.