I have a sample below.

Date Time 1 Time + Day
1/1/2008 11:56:49 PM 1/1/2008 23:56

So basically in the Time+Day column I use the & function to just combine them.

Now I have another column with

Time 2 Date + Time
12:01:03 AM 1/2/2008 '12:01:03 AM

So basically I want to add the Time 2 to the original date, but since it past 12 AM the day is 1 day ahead, how can I do that in a formula?

Thank You