Multiply hours, minutes, and seconds by any number — perfect for timesheets, payroll, project planning, and repetitive shifts.
Multiplying a time duration (hours, minutes, and seconds) by a scalar number can be confusing because time is calculated on a base-60 scale (60 seconds = 1 minute, 60 minutes = 1 hour) instead of a standard base-10 decimal system.
To multiply a standard formatted duration (e.g., cell A1 contains 1:30 representing 1h 30m) by a multiplier (e.g., cell B1 contains 5) in Microsoft Excel or Google Sheets, use this formula:
=A1*B1
Critical Step: To display the result correctly beyond 24 hours without resetting, you must set the cell destination custom format to [h]:mm.
Multiplying time is vital across several professional contexts:
Another popular method is converting your hours and minutes to decimal hours first, multiplying, and then converting back to time. This tool calculates both formats instantly to ensure your payroll or billing is completely precise.
Quick answers to common questions about multiplying hours, minutes, and time factors.
To multiply hours and minutes by a factor manually: (1) Convert the entire duration into total minutes. (2) Multiply those minutes by your scalar factor. (3) Divide the resulting product by 60 to find the total hours, with the remainder representing the final minutes. For example, to multiply 1 hour and 15 minutes (75 total minutes) by 5: 75 × 5 = 375 minutes. 375 ÷ 60 = 6 hours and 15 minutes.
7 hours and 30 minutes multiplied by 5 equals exactly 37 hours and 30 minutes. In decimal hours format, this is equivalent to exactly 37.50 decimal hours.
Yes! If your work hours are already formatted as decimal hours (like 7.5 hours), you can simply multiply that value directly by your factor. For example: 7.5 decimal hours × 5 = 37.5 decimal hours. This simplicity is the primary reason why payroll systems and invoicing applications utilize decimal hours globally.
All the time conversion tools you need, completely free.
Convert hours and minutes to decimal format for payroll and timesheets.
Convert decimal hours back to hours and minutes format (HH:MM).
Convert any decimal time like 7.75 back to hours and minutes instantly.
Add multiple time entries and get total decimal hours for the week.
Calculate gross pay by multiplying decimal hours by your hourly rate.
Full reference chart — every minute from 1 to 60 in decimal format.
Calculate total hours worked between start/end times with break deduction.
Multiply hours, minutes, and seconds by any multiplier factor instantly.