I have a report that is exported from a time-clock program and I need to re-align the punch times. The attached workbook has the data table with what are 3 typical variations of punches I see.
Lines 4 and 5: These are standard daily punches, the punches occur on the same date the first line is the morning, the second line is after lunch. On this one I need to move the second set of punches (in red text) to the end of the previous line (dark blue boxes)
Line 17: This punch is when someone forgets to punch out for lunch/break or works less than 5 hours. For this punch I need to move that end of day punch (green text) to the end of that line (green box)
Lines 21 and 22: This set of punches are for our graveyard shift and the first punch in is usually between 10:00pm and 11:59pm on one day (noted in black bold, 10/19/2013) and the remaining punches for that shift are actually the next day (noted in blue bold, 10/20/2013). I need to move the second set of punches (brown text) to the end of the previous line (dark purple boxes)