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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
