Overtime Question Unlike Others (Pictures Included)

C

C A

I would like to know if I can calculate regular and overtime hours, but not
just using the "anything over 40 hours a week is overtime." I've got a total
of 28.75 hours worked total, but 1 hour of that is overtime (over 8 hours in
1 day). I've included two pictures of my form, one in regular view, the
other in formula audit mode. Basically, I need for the first person's times
to say "28 + .75" and the second to say "40 + 1"

I hope this is understandable and I hope someone can help! :)

Formula Audit Mode:
http://img.photobucket.com/albums/v290/chenchabear/formulaauditmode.jpg

Regular Mode:
http://img.photobucket.com/albums/v290/chenchabear/regular.jpg
 
B

Bob Phillips

Just get the overtime amount with this array formula

=SUM((D9:Q9>8)*(D9:Q9-8))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

new to excel need help with function 4
Pls Help - blank cell/formula issue 7
Sum of Daily Overtime 10
Overtime Calculations 1
Formatting a weekly time sheet 2
overtime hours formula 8
if then formula for total time ;overtime hours versus regular 1
+40 Hours in a Week Overtime Fromula 0

Top