calculating weekly pay

K

kostic2396

i have an excel sheet which calculates total hours worked per/day & hours worked /week, but when I multiply total weekly hours times the pay ($10.00/hour) I don't get the right number:


C D E F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30

47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7 being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
C

Chip Pearson

Excel stores times as a fraction of a 24 hour day (6:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc), so you need to multiply the time
value of hours worked by 24 to get the actual number of hours. So
your formula in column G should be =F7*24*10


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




i have an excel sheet which calculates total hours worked per/day
& hours worked /week, but when I multiply total weekly hours
times the pay ($10.00/hour) I don't get the right number:


C D E
F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM4:00 PM9:00 SUM(D2-C2)
7:00 AM4:30 PM9:30
7:00 AM4:30 PM9:30
7:00 AM4:45 PM9:45
7:00 AM4:30 PM9:30


47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using
(F7*10). F7 being the total hours worked an 10 being the hourly
wage.

When I do this I should get an answer of $472.50, but instead I
get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
F

Frank Kabel

Hi
try
=F7*10*24

--
Regards
Frank Kabel
Frankfurt, Germany

i have an excel sheet which calculates total hours worked per/day &
hours worked /week, but when I multiply total weekly hours times the
pay ($10.00/hour) I don't get the right number:


C D E
F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30


47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7
being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get
$19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
K

kostic2396

thank you, that did it.
i have an excel sheet which calculates total hours worked per/day & hours worked /week, but when I multiply total weekly hours times the pay ($10.00/hour) I don't get the right number:


C D E F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30

47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7 being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
P

P. Balmanno

I agree the formulas wor but are you paying wages for 9+ hours (non-overtime for 1hour) daily?

START FINISH TOTAL HRS RATE PAY
7:00 AM 4:00 PM 9 =(B2-A2)*24 10 $90 =C2*D2
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:45 PM 9.75 10 $97.50
7:00 AM 4:30 PM 9.5 10 $95.00
47.25 =SUM(C2:C6) $382.50 =SUM(E2:E6)



i have an excel sheet which calculates total hours worked per/day & hours worked /week, but when I multiply total weekly hours times the pay ($10.00/hour) I don't get the right number:


C D E F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30

47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7 being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
K

kostic2396

correct, all straight pay - no overtime.

thanx for your help.
I agree the formulas wor but are you paying wages for 9+ hours (non-overtime for 1hour) daily?

START FINISH TOTAL HRS RATE PAY
7:00 AM 4:00 PM 9 =(B2-A2)*24 10 $90 =C2*D2
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:45 PM 9.75 10 $97.50
7:00 AM 4:30 PM 9.5 10 $95.00
47.25 =SUM(C2:C6) $382.50 =SUM(E2:E6)



i have an excel sheet which calculates total hours worked per/day & hours worked /week, but when I multiply total weekly hours times the pay ($10.00/hour) I don't get the right number:


C D E F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30

47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7 being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 
H

Hammerstein

Well that's it then, I quit!! I'm gonna talk to the union lol
correct, all straight pay - no overtime.

thanx for your help.
I agree the formulas wor but are you paying wages for 9+ hours (non-overtime for 1hour) daily?

START FINISH TOTAL HRS RATE PAY
7:00 AM 4:00 PM 9 =(B2-A2)*24 10 $90 =C2*D2
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:30 PM 9.5 10 $95.00
7:00 AM 4:45 PM 9.75 10 $97.50
7:00 AM 4:30 PM 9.5 10 $95.00
47.25 =SUM(C2:C6) $382.50 =SUM(E2:E6)



i have an excel sheet which calculates total hours worked per/day & hours worked /week, but when I multiply total weekly hours times the pay ($10.00/hour) I don't get the right number:


C D E F
START TIME FINISH TOTAL HRS WRKD WEEKLY TOTAL
7:00 AM 4:00 PM 9:00 SUM(D2-C2)
7:00 AM 4:30 PM 9:30
7:00 AM 4:30 PM 9:30
7:00 AM 4:45 PM 9:45
7:00 AM 4:30 PM 9:30

47:15 SUM(E2:E6)


In column G I try to calculate total pay for the week using (F7*10). F7 being the total hours worked an 10 being the hourly wage.

When I do this I should get an answer of $472.50, but instead I get $19.69.

Column G is formatted as "currency" "-$1,234.10"


Any help would be greatly appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

<<Extracting the desired data with an formula>> 10
sort not working properly ? 5
Adding/subtracting time and displaying hours, minutes, seconds 2
Show hours worked or Text "Day Off" 8
Calculating tiome between 17 PM and 6 AM 23
Adding total hours 4
Calendar 2
Sum Time 6

Top