iT邦幫忙

0

Excel formula

marsxd 2017-03-26 14:05:1631830 瀏覽

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
  1. (to be continued...)

圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

立即登入留言