h8rt3rmin8r

zeroPadSeconds.airtable

Nov 30th, 2019
209
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. IF(FIND(".",{dateTime_sec})=0,IF(LEN({dateTime_sec})>0,CONCATENATE(RIGHT(CONCATENATE("0",{dateTime_sec}),2),".000"),"00.000"),IF(FIND(".",{dateTime_sec})=1,CONCATENATE("00",{dateTime_sec}),IF(FIND(".",{dateTime_sec})=2,CONCATENATE("0",{dateTime_sec}),IF(FIND(".",{dateTime_sec})=3,{dateTime_sec},"00.000"))))
RAW Paste Data