Calculate time by hours work

Posted by Samuel Neptune on September 22, 2001 7:36 PM

My problem is that I am unable to multiply hours worked by hourly rate. I format cels a1 and b1 to time format, put in the in and out time. In c1 I subtract the time and in d1 I multiply the time by the hourly rate. When I do this I get the wrong answer.

Please help

thank you

Posted by Robb on September 22, 2001 9:31 PM

Samuel

I think this is because of the way Excel stores the hours and minutes as decimals.

One way of overcoming it is to convert the decimal back. Try this:

- Put the hourly rate in D1
- In E1 type the formula =(C1/0.041666667)*D1
(you could replace D1 in the formula with the actual rate)
- E1 should now show the correct amount

Any help?

Regards

Posted by Ian on September 23, 2001 8:49 AM

in D1 put =C1*24*Hourly rate

any help?

Ian