CONCATENATE Day column, month column, and year column to make a date column

assuming your hours are in G and am/pm is in H, this will work for you...
=--(E4&"/"&F4&"/"&D4&" "&G4&" "&H4), then format as date 3/14/01 1:30 pm from the format list.