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
Microsoft ExcelVisual Basic Classic
Last Comment
Subodh Tiwari (Neeraj)
SOLUTION
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.
ASKER CERTIFIED SOLUTION
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.
You're welcome. Glad we could help.
both worked.