Hello,
can you please help with a formula for below conditions,
I need to put this into a macro.
Any help is appreciated. (Sample Attached)
IF Service (Column AF) = 107 AND DateTime (Column C) < = Date @ 12-00-00.00 Then (Column D) = DateTime + 2 HRS
IF Service (Column AF) = 109 AND DateTime (Column C) < = Date @ 12-00-00.00 Then (Column D) = DateTime + 5 HRS
IF Service (Column AF) = 313 AND DateTime (Column C) < = Date @ 12-00-00.00 Then (Column D) = DateTime + 1 Day @ 18-00-00.00
IF Service (Column AF) = 123 AND DateTime (Column C) < = Date @ 12-00-00.00 Then (Column D) = DateTime + 1 Day @ 12-00-00.00
IF Service (Column AF) = 124 AND DateTime (Column C) < = Date @ 12-00-00.00 Then (Column D) = DateTime + 1 Day @ 17-00-00.00
IF Service (Column AF) = 107 AND DateTime (Column C) < = Date @ 17-00-00.00 Then (Column D) = DateTime + 1 Day @ 10-00-00.00
IF Service (Column AF) = 109 AND DateTime (Column C) < = Date @ 17-00-00.00 Then (Column D) = DateTime + 1 Day @ 13-00-00.00
IF Service (Column AF) = 313 AND DateTime (Column C) < = Date @ 17-00-00.00 Then (Column D) = DateTime + 1 Day @ 18-00-00.00
IF Service (Column AF) = 123 AND DateTime (Column C) < = Date @ 17-00-00.00 Then (Column D) = DateTime + 1 Day @ 12-00-00.00
IF Service (Column AF) = 124 AND DateTime (Column C) < = Date @ 17-00-00.00 Then (Column D) = DateTime + 1 Day @ 17-00-00.00 Sample.xlsx
both worked.