View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
H.L.S. 11 West H.L.S. 11 West is offline
external usenet poster
 
Posts: 1
Default excel formula to recognize overtime in a day as you prep schedule

Schedule template set up going to row 1 & 2 (top to bottom) for times in and
out. I got all the other formulas. I only need the one that recognizes when
to hit the overtime rate as I'm prepareing the schedule. Example: The
employee gegins overtime rate at any part of a day after hitting 40 hours.