Date & Time

1. Convert String to Time format

• Desc: 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

2. (to be continued...)