excel formula to recognize overtime in a day as you prep schedule

[Guest]

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.

 

[Guest]

post more specifics

what do you want to have happen if the sum of hours in a range > 40

 

[Peter]

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