h8rt3rmin8r

normalizeHour.airtable

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