I am having a problem. I have the time as below (see picture)
Now I want to conver this into JUST
in text format as prior data is in similar format (when I say prior data, the data available to me from a point before)
The prior data is entered on excel as this
'14:30 by a user...then the use of computerized scripts made the time look like above. But for reporting purposes, I need to make them look like old data. Thats the history of this.
Thanks for your time!