Calculate total for rate times hours in Excel?
 

I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for
the week worked by an employee. I want to take that total and multiply it by
that employee's hourly rate. I have tried the obvious of multiplying the
cells but that doesn't work.
--
Jenn

Calculate total for rate times hours in Excel?
 

Hi,

Convert the time to decimal by multiplying by 24 and then multiply by hourly
rate. So with a time in A1

=A1*24*25

Where 25 is the hourly rate.

Mike

"whitjl143" wrote:

I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for
the week worked by an employee. I want to take that total and multiply it by
that employee's hourly rate. I have tried the obvious of multiplying the
cells but that doesn't work.
--
Jenn

Calculate total for rate times hours in Excel?
 

Format the cell as Currency and multiply by 24.

whitjl143 wrote:

I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for
the week worked by an employee. I want to take that total and multiply it by
that employee's hourly rate. I have tried the obvious of multiplying the
cells but that doesn't work.

Calculate total for rate times hours in Excel?
 

I forgot that Excel will try and be helpful and format this as a time so
re-format as general

Mike

"Mike H" wrote:

Hi,

Convert the time to decimal by multiplying by 24 and then multiply by hourly
rate. So with a time in A1

=A1*24*25

Where 25 is the hourly rate.

Mike

"whitjl143" wrote:

I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for
the week worked by an employee. I want to take that total and multiply it by
that employee's hourly rate. I have tried the obvious of multiplying the
cells but that doesn't work.
--
Jenn