Adding Date and Time to Yield Date

[fengfeng]

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

[NBVC]

if you do =A1+B1 it should add the time to the original date (assuming time in B1 and date in A1).

If you are copying the formula down and always want to reference original date.... then make A1 absolute, i.e. =$A$1+B1 copied down.