Converting Military time into standard 12 hours

Hammermill21
✭✭✭✭✭
Hello I am pulling data that comes in as military time and I need to convert it to 12 hours. Does anyone know how to do that?
Thank you!
Best Answer
-
Take a look through THIS THREAD. There are currently 4 pages worth of comments, but I believe there should be a solution tucked away in there for you. If you are unable to find something or need help modifying something to fit your needs, feel free to let me know.
Answers
-
Take a look through THIS THREAD. There are currently 4 pages worth of comments, but I believe there should be a solution tucked away in there for you. If you are unable to find something or need help modifying something to fit your needs, feel free to let me know.
-
Thank you, Paul!
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!