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

Options

Hello,

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?

Thanks

Best Answer

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

    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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!