Overtime Question Unlike Others (Pictures Included)

G

Guest

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

overtime hours formula 8
if then formula for total time ;overtime hours versus regular 1
Need help calculating overtime to date 8
Overtime Calculations 1
Complex overtime calculation 2
Overtime 4
Adding Multiple Lines when the Function is Satisfied 1
Overtime for 8 hour and 40 hour 1

Top