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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!