3rd Shift hours

[kholm]

Here we have three shifts for which I make a productivity report. By taking the hours put in by the person, we can see how much time they spent doing data entry, or other "work". The problem is with third shift. The hours we get from our time clock are military time, therefor switches to a different day at midnight. The hours we get from the computers is done by session and when the session started. If it started on Monday, March 24 and was completed on Tuesday, March 25, the hours are recorded as Monday.

So, when I go to print out our report those who work on Third shift have 1 hour on Monday in the time clock and 6 hours on Monday in the computer. This throws all the numbers off. Any suggestions?

 

[FoFa]

Sure identify the problem hours by total hours > End time, so 6 hours total > 2:00
Than get the current hours for Monday, I think datediff can be used here.
Take those hours minus the total hours for those left for Sunday night.