Converting Time to Military Time
I am trying to convert time entered into military time so intially set it up to add 12 to the rows that clock in and choose PM but then that adds 12 hour to noon making it 24. So I changed the formula to the one below but it is not working correctly?
Appreciate any help!! Thank you so much!!
=IFERROR(IF(AND([Start Day - Time In AM/PM]@row = "PM", [Start Day - Time In Hours]@row = "12"), [Start Day - Time In Hours]@row, (IF(AND([Start Day - Time In AM/PM]@row = "PM", [Start Day - Time In Hours]@row <> "12"), [Start Day - Time In Hours]@row + 12, IF([Start - Time In AM/PM]@row = "AM", [Start Day - Time In Hours]@row, "")), " "))
Answers
-
I figured this out! I had something wrong in the last IF statement. Not sure what but when I tested them all that one didn't work so I re-wrote it and it did! Thank you!
-
I'm glad you were able to fix it!
Looks like your column name was just missing the word "Day" after "Start" in the second-to-last reference.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Yes you're right! Thank you! So crazy how you can look at something so many times and not see it.
Thank you again!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!