jassybun Member Feb 16, 2019 #1 I am trying to combine 3 columns, column a: 1/2/2019, column b: 09:45, and column c: am/pm. Midnight would be 12:00, AM and Noon is 12:00, PM. I need to subtract it from another column which already has the date time in the format mm/dd/yyyy hh:mm:ss am/pm. Last edited: Feb 16, 2019
I am trying to combine 3 columns, column a: 1/2/2019, column b: 09:45, and column c: am/pm. Midnight would be 12:00, AM and Noon is 12:00, PM. I need to subtract it from another column which already has the date time in the format mm/dd/yyyy hh:mm:ss am/pm.
jassybun Member Feb 16, 2019 #3 AlanSidman said: Are all columns text values? Click to expand... I am not sure - I am attaching some sample data. Attachments example2.xls 43 KB · Views: 14
AlanSidman said: Are all columns text values? Click to expand... I am not sure - I am attaching some sample data.
Hui Excel Ninja Staff member Feb 16, 2019 #4 D2: =A2+TIMEVALUE(B2)+IF(C2="PM",0.5,0) Then apply a Custom Number format to D2 of: mm/dd/yyyy hh:mm:ss AM/PM Then copy down A2 is a Date B2 is Text
D2: =A2+TIMEVALUE(B2)+IF(C2="PM",0.5,0) Then apply a Custom Number format to D2 of: mm/dd/yyyy hh:mm:ss AM/PM Then copy down A2 is a Date B2 is Text
