Hours worked X Pay Rate

[franck]

I have a sheet that calculates total number of hours worked in a week. I need to multiply this total by a rate of pay. Hours worked cells are formatted to time and Rate of pay cells are formatted to currency/number. When I try hrs worked cell X Rate of pay cell I get a silly answer. Can anyone help please?

 

[Mark W.]

On 2002-04-16 07:11, franck wrote:
I have a sheet that calculates total number of hours worked in a week. I need to multiply this total by a rate of pay. Hours worked cells are formatted to time and Rate of pay cells are formatted to currency/number. When I try hrs worked cell X Rate of pay cell I get a silly answer. Can anyone help please?

You're getting a "silly" answer because Excel stores time values as a fraction of a day. For example, 6:24 is stored as 0.266666666666667. You need to covert this value to hours to calculate pay based on an hourly rate. Suppose A1 contains your work time, 6:24, and B1 contains your hourly rate, $2.50. Then =A1*24*B1 returns your pay, $16.00.
This message was edited by Mark W. on 2002-04-16 07:25