h8rt3rmin8r

normalizeSecond.airtable

Nov 30th, 2019
201
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({dt_s}),".",""),":",""),",",""))>2,"00",IF(RIGHT(CONCATENATE("00",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({dt_s}),".",""),":",""),",","")),2)>59,"00",IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({dt_s}),".",""),":",""),",",""))>2,"00",RIGHT(CONCATENATE("00",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM({dt_s}),".",""),":",""),",","")),2))))
RAW Paste Data