Please help on time sheet

[anonymous354]

Hi,

I am using Excel to create a simple time sheet. When I
take the result of the deduction between time in and time
out, and multiply it by the hourly wage, I get a number
that does not correspond to the right number.

For example, if the amount build is 5:30 (hours:minutes)
and I multiply it to $10, the product is 7:00. It is
obviously the wrong product, the product should be
$55.00. Thus, what should I do in order for Excel to
recognize 5:30 as numbers?

Thank you.

 

[Frank Kabel]

Hi
try the following:
1. Format the target cell as standard or general
2. Use the following formula:
=(A1*24)*B1
A1 stores your time and B1 your hourly wage. You have to multiply the
time with 24.

For more information regarding time calculations have a look at
http://www.cpearson.com/excel/datetime.htm#AddingTimes

HTH
Frank

 

[Biff]

Try this:

=(Time_out - Time_in)* 24 * rate_of_pay

Format as GENERAL

Biff

 

[anonymous354]

Thank you very much Biff and Frank, it worked!

By the way, what book would you recommend that will make
me more proficient in Excel?

Thanks.

 

[Mike]

Also try this:

=(Time_out - Time_in) / "1:0" * rate_of_pay

 

[Biff]

Here's a link to a list of books that will help. Books by
John Walkenbach are very popular.

http://contextures.com/xlbooks.html

Biff