 # Excel Formula-Macro

Hello,
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
Microsoft ExcelVisual Basic Classic Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
SOLUTION
Ejgil Hedegaard

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.