How to Multiply Time by an Hourly Rate in Excel
Question details
The user needs to calculate a total currency amount by multiplying a time duration value by an hourly rate in Excel.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Calculating total wages, project costs, or payroll payments based on recorded time formats and a set hourly rate.
- Observed behavior
- The user wants to return the correct currency amount, which requires overcoming Excel's default fractional day storage format for time values.
Ensure that your time values are properly formatted as Time (e.g., 15:28) and your hourly rate is formatted as a Number or Currency.
Use a formula multiplying by 24
Multiply the time value by 24 to convert Excel's fractional day format into standard decimal hours before applying the hourly rate.
Excel inherently stores time as a fraction of a 24-hour day. For example, 12 hours is stored as 0.5. To calculate wages correctly, you must convert this fractional day into standard decimal hours by multiplying the time value by 24. Without this step, your total calculated wage will be drastically lower than expected.
Click on the blank cell where you want the final currency amount to appear.
Type the formula =C1*B1*24, assuming cell C1 contains your hourly rate and B1 contains your time value.
To ensure your currency result is strictly limited to two decimal places, wrap the calculation in the ROUND function: =ROUND(C1*B1*24, 2).
Press Enter to execute the formula. If the resulting value displays as a time format, right-click the cell, select 'Format Cells', and change the format to Currency.
Calculate Pay Rates Easily with WPS Spreadsheet
WPS Spreadsheet fully supports Excel formulas and time formatting, allowing you to accurately multiply time by an hourly rate for payrolls or invoices. It is a highly compatible and lightweight application for managing all your data tasks.
- 1. Open your timesheet: Launch WPS Spreadsheet and open the document containing your recorded hours and hourly rates.
- 2. Apply the calculation formula: Select the target cell and input the formula =ROUND(RateCell*TimeCell*24, 2) to successfully convert the time to decimal hours and multiply it by the rate.
- 3. Format as Currency: Right-click the calculated cell, select 'Format Cells', and choose the Currency format to properly display the total wage amount.
Frequently Asked Questions
Why does my calculation result show up as a weird time like 12:00 AM?
When multiplying time by a number, the software often automatically inherits the Time format from the cells used in your formula. To fix this, simply right-click the result cell, select 'Format Cells', and change the Number format from Time to Currency or General.
How can I calculate pay if the total hours worked are over 24?
If an employee works more than 24 hours, you must apply the custom format [h]:mm to the time cell. The brackets ensure the software does not reset the clock to zero after 24 hours. Once properly formatted, the formula =Rate*Time*24 will still calculate the correct total amount.
How do I multiply an hourly rate by a standalone number of minutes?
If your time is recorded as a standard whole number of minutes instead of an actual time format (for example, typing 45 to represent 45 minutes), you need to divide the minutes by 60 to convert them into decimal hours first. The formula would be =(Minutes/60)*HourlyRate.
