Thanks:  0
Likes:  0

Thread: Hours worked X Pay Rate

1. 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?

2. 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 ]

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•