Military Time

CyberJL

I have a form populating a sheet. I need to know what HOUR (in military time, 00-24) each row was added so I can count the ones that came in outside of business hours.

Can anyone assist?

Paul Newcome

Below is a link to a thread that contains a number of time based solutions including how to convert 12 hour into 24 hour times.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time