Convert text (19-NOV-2020 11:30:38 AM) into date



I am looking for a way to convert text in the following format: 19-NOV-2020 11:30:38 AM into a full date (with hour and minutes).

Any suggestions?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    HERE is a link to a post that has multiple time based solutions.

    You are not going to be able to create a date/time stamp type column that directly functions as such, but you can use hidden helper columns to parse out the data and run the calculations. Feel free to browse the listed solutions and then let me know if you can't find one that works for you or if you need help adapting one of them.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!