Hi
Please help me regarding my excel time sheet formula. It's about computing the overtime, it has a condition that's why I can't think the right formula. The conditions are as follows:
1. every week days (i.e. every Mondays to Fridays) overtime will start at 6:00 AM.
2. on week ends (i.e. every Saturdays and Sundays) break time (12:00 PM to 1:00 PM) is not counted or not included in overtime computation.
Attached is my sample time sheet. Some of the areas are already formulated such as the tardy and undertime.
Any help is greatly appreciated.
Thank you in advance.
Gerard
Bookmarks