Thread: [Solved] Timesheet formula
View Single Post
 
Old 05-26-2011, 02:34 PM
IndCom IndCom is offline Windows XP Office 97
Novice
 
Join Date: May 2011
Posts: 8
IndCom is on a distinguished road
Default

Bear in mind that somedays are 12 hour shift days that are REGULAR WORKED HOURS.

Basically, in my case

Saturday & Sunday= 12 hour shifts & are REGULAR HOURS
Thursday & Fridays= 8 hour shifts and are REGULAR HOURS
This makes a 40 hour workweek of REGULAR HOURS.

Anything over this 40 hours is considered OVERTIME HOURS. But, I'm trying to break it down into a daily log basis, or have it show as "0.0" for any OVERTIME that day.


Now I know I've confused the issue.
Reply With Quote