I don’t think date format will change, however someone else reading this may want it in “proper” format. None of my sources are in military time, my only reason for involving it is to sort, so, as long as they can sort correctly I need the following: Yes, I am adding date now… I realized I need to span over a few days. My final product will always be in 12:04:00 AM format sorted bottom to top. as for 12 hr time, I need 12:04:00 AM format. Hey that is the general idea of what I am looking for, however, I need to have seconds accounted for. I can use either of these to select any of my times, but, I am not able to make the conversion or replacement with regex: This is all going to be part of a macro, so, multiple steps are ok. If seconds are not available in source time, ie… 12:01 PM, I would want to make the final number be something like: 12:01:00 PM or add three spaces in the front, so that the times line up like this:
My thought was to convert them to military time, sort, then convert back in a defined format such as hh:mm:ss AM or PM.
I ultimately want to be able to sort them in order of time either ascending or descending with any combination of the above formats. I have looked at the other posts on here ( ) or ( ) and am not able to find what I want.