Time in Excel and sorting

[Ron Purpura]

Hello All
Having a bit of an issue converting time.Attached is the data I am working with

In column E is the time pulled from an EMR, but when the data is exported, some cells have a blank before the actual time, SO in column K, I used the trim function to rid myself of the blank space, but my result for times between 10:00 and 1:00 appear as a decimal and will not convert to a time in column L. I would like these times to appear as Military time if possible as my objective is to be able to sort the times in chronological order. Any help would be much appreciated
Thanks
Ron

[Jonmo1]

In column K, try

=TRIM(E2)+0

And format column K as the Military Time of your choice.

[Ron Purpura]

Thank you very much Jonmo. Can you tell me what the +0 is doing in the formula?

[Jonmo1]

You're welcome

The TRIM function returns a TEXT value, but TIME is a numeric (decimal) value, formatting makes it look like a time.

The +0 is just coercing the Text string into a Numeric Time Value.