h8rt3rmin8r

normalizeMinute.airtable

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