Column Formulas

JGettle

Hello, I found this formula to convert time into military time but I would like the formula to be a column formula, so it automatically updates. It looks like I'm not able to convert it from a cell to a column formula however, any suggestions?

=(VALUE(LEFT([Modified Time]@row, FIND(":", [Modified Time]@row) - 1)) - IF(VALUE(LEFT([Modified Time]@row, FIND(":", [Modified Time]@row) - 1)) = 12, 12, 0) + IF(RIGHT([Modified Time]@row, 2) = "pm", 12, 0)) + ":" + MID([Modified Time]@row, FIND(":", [Modified Time]@row) + 1, 2)

MPath

Not sure what military time is, but I assume you mean 24h notation?

Have you looked at https://help.smartsheet.com/function/time ?

Weird that it's not just an option in the rop-right menu in Smartsheet (like date/currency/etc.)