Excel Biweekly SS with Weekly Overtime totals

D

D4Taz

I have just started payrolls on a bi-weekly schedule. How do I get my formula
to figure the hours as weekly 40 plus overtime rather than 80 and over is
overtime if they work 32 hrs one week and 45 the next it should have 5 hrs
overtime....Its probably an easy formula but I am drawing a blank....Any help
will be much appreciated!!
 
N

N Harkawat

If Week1 hrs are in cell A1 and week 2 in Cell B1
Overtime for the 2 weeks is

=max(0,A1-40)+max(0,B1-40)
 

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

Top