View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D4Taz D4Taz is offline
external usenet poster
 
Posts: 2
Default Excel Biweekly SS with Weekly Overtime totals

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!!