Calculate total for rate times hours in Excel?

[whitjl143]

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.

 

[Mike H]

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

 

[Bob I]

Format the cell as Currency and multiply by 24.

 

[Mike H]

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

Mike