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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!