Time in 24 hours

Please help! 

I am working on a IT Change Request sheet where the request is submitted by Forms. For a change to take place we require a specific time to be entered. I know Smartsheet currently does not have a time option, but is it possible to have the Implementation Time, whether it's entered as AM or PM or in a 24 hour format, all be converted into a 24 hour format only? 

I am looking for a solution so I'm able to sort it by the date and then by the Implementation Time. In the example, currently it's not being sorted correctly when it comes to the Time. It's very important to get this column to sort correctly. Any help would greatly be appreciated. Even if I have to create a hidden column so it converts the time into a decimal so I'm able to get it to sort properly is fine too. 

Thanks again! 

CC Time.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!