Hello,

I have been looking for an answer to my dilemma. Below, I have Cell A1-A8 (tried attaching this to the thread but not letting me), it displays the date and time.

Log Date
07/31/2019 7:47:56 tt
07/31/2019 7:46:21 tt
07/31/2019 7:39:25 tt
07/31/2019 6:53:55 tt
07/31/2019 6:38:03 tt
07/31/2019 5:27:43 tt
07/31/2019 5:16:53 tt

The above times are in UTC (7 hours behind) and I want to know if there is a way to convert it to something like below:

Log Date
07/31/2019 2:47p
07/31/2019 2:46p
07/31/2019 2:39p
07/31/2019 1:53p
07/31/2019 1:38p
07/31/2019 12:27p
07/31/2019 12:16p

Any help would be appreciated.