Date & Time

Convert String to Time formatDesc: Convert string: [mm/dd/yyyy HH:MM:SS (AM/PM)] (12hr) to time: [yyyy/mm/dd HH:MM:SS] (24hr)Formula: (A2 is the plain string.)
=DATE(MID(A2,7,4),MID(A2,1,2),MID(A2,4,2))+TIME(IF(AND(MID(A2,21,2)="PM",MID(A2,12,2)<"12"),MID(A2,12,2)+12,MID(A2,12,2)),MID(A2,15,2),MID(A2,18,2))Example:
-11/25/2016 11:08:18 AM => 2016/11/25 11:08:18
-11/19/2016 12:08:49 PM => 2016/11/19 12:08:49
-11/21/2016 02:34:56 PM => 2016/11/21 14:34:56(to be continued...)