Reply To: Time Travel

Inner Circle › Ask Smartsheet Guru Crew Anything › Time Travel › Reply To: Time Travel

February 5, 2026 at 6:47 pm #8474
Darren
Keymaster

    Michael,
    You can use your new 12 Hr modified time column and use this:

    =TIME([Modified Time]@row, 1, 2)

    The “1” in the function will display in 24hr time, the “2” makes it display in hh:mm format.

    You could do this all in one formula when you extract from the Modified system column, by adding those additional parameters into the TIME() function like this:

    Modified Time column formula:
    =TIME(RIGHT([Modified DateTime]@row, 8), 1, 2)