Ok here is the problem. I need some code to break apart any 2 date/times and split those records based on shift and days.
For example I have an in punch of 1/23/2015 5:52:18 AM and an out punch of 1/24/2015 4:24:54 AM. Since the end goal is to report on shift and/or date I need to break that single record up into this. Just kind of stuck on the logic to evaluate this. Ideally this would be handled in a sql stored proc, but i could also do it on the VBA front end. The shifts are 8 to 8's. (8a to 7:59:59 p and 8p to 7:59:59a)
Date Start End Shift
23-Jan 5:52:18 AM 7:59:59 PM 1
23-Jan 8:00:00 PM 11:59:59 AM 2
24-Jan 12:00:00 AM 4:24:54 AM 2