Try something like this in C2

=IF(B2<TIME(2,0,0),A2,A2+1)+TIME(12,30,0)

HTH,
Barb Reinhardt

"Little Penny" wrote:


I'm trying to create a formula to determine a due date. My due dates
are calculate base on the date in column "A" and the time in column
"B". The due date window is 2am to 1:59am. If and order is received
by 1:59am it is due that same day by 12:30pm. If it is received after
2am it is due the following day by 12:30. The tricky part for me is
the time between 12am and 1:59am. Any help would appreciated.

A few examples


A B C
DATE RECEIVED TIME RECEIVED Would be Due By
3/27/2009 9:52:10 3/28 by 12:30pm
3/27/2009 14:14:17 3/28 by 12:30pm
3/28/2009 0:28:25 3/28 by 12:30pm
3/28/2009 1:19:02 3/28 by 12:30pm
3/28/2009 2:05:35 3/30 by 12:30pm
3/28/2009 2:49:20 3/30 by 12:30pm



Thanks


Little Penny
T