Multiply Time by a Number in Excel: Formula and Tips

To multiply a time value by a number in Excel, enter a formula such as =A2*B2, where A2 contains the time and B2 contains the multiplier. Format the result as an elapsed time, such as [h]:mm, if the total could reach 24 hours. This is useful for scaling a duration—for example, calculating how long a task takes at a different rate or adding up hours for several shifts.

What You’ll Need

An Excel workbook with a cell containing a real Excel time or duration, such as 2:30 for two hours and 30 minutes.
A cell containing the number to multiply by. Use 1.5 to calculate one and a half times the duration, or 3 to calculate three times the duration.
A result cell where you can enter a formula and choose an appropriate time format.

Excel stores times as fractions of a day: one hour is 1/24 of a day, and 12:00 is half a day. Multiplying a time by a number scales that fraction. The calculation is straightforward, but the result’s number format determines whether it looks like a useful duration or an unexpected decimal or clock time.

Step-by-Step

Set up the time and multiplier. Put the time or duration in one cell and the number in another. For example, enter 2:30 in A2 and 1.5 in B2. Excel will normally recognize 2:30 as two hours and 30 minutes when you enter it in a blank cell. Enter the multiplier as a number, not as text; a decimal such as 1.5 is valid, and a whole number such as 3 is valid. Add headings such as Duration and Multiplier if you want the purpose of each column to be clear.
Select the result cell and enter the multiplication formula. With the duration in A2 and the multiplier in B2, enter =A2*B2 in C2 and press Enter. The asterisk is Excel’s multiplication operator. In this example, the calculation is 2 hours 30 minutes multiplied by 1.5, which returns 3 hours 45 minutes. Excel calculates the underlying value correctly even if the cell initially displays a decimal or a clock-style result.
Apply an elapsed-time format. Select C2, then press Ctrl+1 on Windows to open Format Cells. Choose the Number tab, select Custom, and type [h]:mm in the Type box. Select OK. The square brackets make Excel show the total elapsed hours rather than resetting the hour count after each 24-hour period. On a Mac, select the cell and press Command+1 to open Format Cells; the Custom category and format code work the same way. If the total is guaranteed to be under 24 hours, the built-in time format or a custom format such as h:mm can also display it, but [h]:mm is safer for durations.
Check that the displayed answer makes sense. With A2 set to 2:30 and B2 set to 1.5, C2 should display 3:45 when formatted as [h]:mm. You can verify the arithmetic in minutes: 2 hours 30 minutes is 150 minutes, and 150 multiplied by 1.5 is 225 minutes, or 3 hours 45 minutes. If the cell displays a number such as 0.15625 instead, the calculation may be right but the result cell is formatted as General or Number. Apply the elapsed-time format rather than changing the formula.
Copy the formula down for more rows. If each row has a duration in column A and a multiplier in column B, select C2 and drag the fill handle—the small square at the lower-right corner of the selection—down the column. Excel adjusts the references for each row, so the next row uses A3 and B3. You can also copy C2, select the destination cells, and press Ctrl+V on Windows. On Mac, use Command+C and Command+V. To fill a selected range down, Ctrl+D works in Windows; the Mac shortcut is Command+D in Excel. Check a few rows to ensure the time and multiplier are on the intended row.
Choose a format that matches the way you want to report the answer. Use [h]:mm for total hours and minutes, including results beyond 24 hours. Use [h]:mm:ss if seconds matter. To show a decimal number of hours instead of a clock-style duration, keep the calculated time in one cell and convert the day fraction to hours in a separate result cell. With the duration in A2, the multiplier in B2, and a decimal-hours result in C2, enter =A2*B2*24; for the example values 2:30 and 1.5, this returns 3.75 hours. Format C2 as Number if you want to see 3.75 rather than a time display. Multiplication by 24 converts Excel’s day-based time value to hours.
Use absolute references if the multiplier is shared by every row. If durations are in A2:A20 and one common multiplier is in B1, enter =A2*$B$1 in C2. The dollar signs keep the reference to B1 fixed as you fill the formula down, while A2 changes to A3, A4, and so on. Format the results as [h]:mm. For instance, if B1 contains 2, a duration of 2:30 in A2 returns 5:00. Use this approach only when every row should use the same multiplier; if each row has its own multiplier, use a relative reference such as B2 instead.

These formulas multiply the entire time value, not just the hour portion. For example, multiplying 1:45 by 2 doubles both the one hour and the 45 minutes, returning 3:30. You do not need to convert the minutes separately when the input is a valid Excel time value.

Common Mistakes

Leaving the result formatted as General. Excel may show a decimal such as 0.15625, which represents a fraction of a day, instead of 3:45. Set the result to [h]:mm; do not alter a correct formula just because the display is unfamiliar.
Using a clock format for a long duration. A normal h:mm display resets after 24 hours. A result of 27 hours can appear as 3:00, which looks like the calculation lost a day. Use [h]:mm to display 27:00.
Entering the multiplier as text. A value imported with a leading apostrophe or pasted with spaces may not act like a number. Re-enter it as a numeric value, or check its alignment and cell format. Changing a text-formatted cell to Number alone may not convert text already stored in it.
Confusing time of day with elapsed time. A value such as 11:00 can mean 11 a.m. on a clock or a duration of 11 hours. Multiplication treats it as a duration. If you mean a start time, multiplying it is usually not the right operation; consider what elapsed interval the calculation should represent.
Multiplying by a percentage without considering the meaning. A multiplier of 50% is 0.5, so it returns half the duration. That is different from increasing a duration by 50%, which requires a multiplier of 1.5.

Tips

Use consistent entries in a column. Enter durations in a recognizable time format such as 1:15 or 12:30, and keep multipliers numeric. Consistency makes copying formulas and spotting mistaken values easier.
Label the units. Headings such as Duration (h:mm), Factor, and Total duration help distinguish a multiplier from a number of hours. If the output is decimal hours, label it accordingly so readers do not mistake 3.75 hours for 3 hours and 75 minutes.
Include seconds when the input needs them. A custom display of [h]:mm:ss shows total hours, minutes, and seconds. A format that omits seconds can hide small differences without changing the stored result.
Use a table for growing lists. In Excel for Microsoft 365 on Windows, select the data and choose Insert > Table. When you enter a formula in a table column, Excel can carry it into new rows automatically. The formula can still use normal cell references; check that the table’s calculated column follows the intended pattern.
Keep the calculation and its presentation separate. Cell formatting changes how a number appears, not the stored value. This lets you display the same calculated duration as hours and minutes or as decimal hours in different cells, depending on what your report needs.

Troubleshooting

The answer is a decimal. This usually means the result cell is displayed as General or Number. Select it, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, and apply [h]:mm. A decimal such as 0.25 represents six hours because a full day is 1.

The answer shows a time that is too small. If the duration exceeds 24 hours and the result shows only the remainder, change the format from h:mm to [h]:mm. The formula may already be correct. For example, a 30-hour total can display as 6:00 in a clock-style format, but it displays as 30:00 with the bracketed-hour format.

The formula returns #VALUE! or will not calculate. Check that both referenced cells contain numeric values rather than text. Click each input and inspect the formula bar. Re-enter a time directly in the cell, remove leading or trailing spaces from pasted data, and enter the multiplier as a number. If Excel displays the formula itself rather than a result, the cell may be formatted as Text; change it to General, then re-enter the formula. Also check that Show Formulas is not turned on from the Formulas tab.

The result is wrong after copying down. Click a copied formula and inspect the cell references. Relative references move with each row, so a row-by-row multiplier should refer to the matching row. If one multiplier is meant to stay fixed, use an absolute reference such as $B$1. Check that the fill handle did not skip rows or extend the formula into an unrelated column.

The answer looks like a date or an unusual number. Excel uses the same underlying serial-number system for dates and times. Apply a time or duration format to the result. If the inputs came from another system, confirm that Excel recognized them as actual time values; text that merely looks like a time will not reliably behave as one. Re-entering the value or converting the imported data may be necessary.

Frequently Asked Questions

Can I multiply a time by a decimal, such as 1.25?
Yes. A decimal multiplier scales the duration proportionally. For example, 1.25 means one and a quarter times the original duration. If A2 contains 8:00 and B2 contains 1.25, use =A2*B2 in C2; the result is 10:00. Format C2 as [h]:mm. The decimal does not mean 1 hour and 25 minutes; it is a multiplier.

How do I multiply a duration by a number of days?
If the number represents how many times to repeat a duration, use it as the multiplier in the same way. For instance, a 7:30 duration multiplied by 4 gives 30:00, which you can display with [h]:mm. If instead you are trying to calculate a calendar date several days later, you are working with a date value and should distinguish that task from scaling an elapsed duration.

How can I show a result as decimal hours?
Excel stores a time as part of a day, so multiply the calculated duration by 24 to express it in hours. With A2 containing the time and B2 the multiplier, enter =A2*B2*24 in C2, then format C2 as Number. For 2:30 multiplied by 1.5, the result is 3.75 hours: 2.5 hours times 1.5 equals 3.75. This is decimal hours, not hours and minutes.

Why does multiplying a time by 2 sometimes show the same clock time?
The result may have crossed a 24-hour boundary, and a clock-style display shows only the time within a day. For example, doubling 12:00 gives 24 elapsed hours, which may display as 0:00 or 12:00 depending on the format. Apply [h]:mm to show the total duration. Also confirm the multiplier cell contains the numeric value 2.

Can I multiply a start time by a number?
You can, but the result scales the time value as a duration; it does not calculate a later appointment time in the usual sense. To find an end time, add the elapsed duration to the start time instead, then choose a format that displays the intended clock time or elapsed total. Be clear about whether your cells represent a clock time or a length of time.

Will the formula work in Excel for the web?
Yes. The basic multiplication formula and Excel time values work in Excel for the web as well as Microsoft 365 for Windows. The ribbon layout can differ slightly, but select the result and use the number-format controls to choose a time format or a custom elapsed-time format if available. If the custom format controls are limited in your browser, open the workbook in the desktop app to set [h]:mm.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.