Calculate total for rate times hours in Excel?

W

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.
 
M

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
 
M

Mike H

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top