View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teri Teri is offline
external usenet poster
 
Posts: 77
Default HELP!! Formula for calculating overtime

I'm hoping someone can help me. I can't seem to figure out a formula to
calculate OT for my staff. Regular hours per day are 7.5. I'm looking to
create a formula for banking time which will break out in two columns hours
worked over the regular 7.5 hours per day up to 11 hours per day, and in the
second column the hours worked over 11 hours per day.

Does anybody have any ideas?

Thanks so much!!