View Single Post
  #1   Report Post  
jasperPcuccumber
 
Posts: n/a
Default how do I write a formula that will figure weekly overtime?

I am setting up a payroll worksheet. I need a cell to show total hours, one
for regular time and one for over time. What formatting or formula can I use
to figure over time and straight time based on 40 overtime rule? (anything
over 40 hours in a week is overtime)