Converting Time to Military Time

Kendra Hillmer

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, "")), " "))

Kendra Hillmer

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!

Genevieve P.

Hi @Kendra Hillmer

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

Kendra Hillmer

Yes you're right! Thank you! So crazy how you can look at something so many times and not see it.

Thank you again!