Gmail Date Conversion

[linaeum66]

Hello, this should be an easy one for you guys. Gmail is exporting timestamps to a googlesheet with the default Gmail format of:

"March 16, 2018 at 11:41PM"

Could someone please help me to convert this in an adjacent cell to just the time in military time?

For example:


"March 16, 2018 at 11:41PM" changed to "2341"
Thanks so much!!

 

[Dryver14]

No worries, I shouldn't really of hijacked the post without explaining properly