I need to roll back the values of the second 12 hour shift which is from 7:00
P.M. to 6:59 A.M. to the previous days date.

Example, any production run beginning on the 7:00 P.M. 12 hour shift (on
11-30-04 = cell W11) going past 12:01 A.M and ending at or prior to 6:59 A.M
12-01-04 belongs to the 11-30-04 date, or ending on 12-01-04 at 3:45 A.M.
roll these values back and group it/them into the previous day's (11-30-04)
production numbers.

Begin production run date and time:
W11 = 11-30-04 7:20 P.M ends 11-30-04 10:30 P.M.
W11 = 11-30-04 10:31 P.M. ends 12-01-04 12:10 A.M.
W11 = 12-01-04 12:11 A.M. ends 12-01-04 3:52 A.M
W11 = 12-01-04 3:53 A.M. ends 12-01-04 6:59 A.M

I would like all values from 12-01-04 12:01 A.M. to 12-01-04 6:59 A.M.
rolled back to the values for 11-30-04.

Is this possible? If so how? Show examples please?

Thanks