W.E.B
asked on
Excel Formula-Macro
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome. Glad we could help.
ASKER
both worked.