Please help on time sheet

  • Thread starter Thread starter anonymous354
  • Start date Start date
A

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.
 
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.
 
Back
Top