View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_55_] Peter[_55_] is offline
external usenet poster
 
Posts: 24
Default excel formula to recognize overtime in a day as you prep schedule

Hi H.L.S,

You will find a fully working timesheet with overtime recognition at
J-Walks.
Here's the adres:
http://j-walk.com/ss/excel/files/timesht.htm

Regards,
Peter
"H.L.S. 11 West" <H.L.S. 11 schreef in
bericht ...
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.