Just spotted something … all of the date / times in @Chimanimani 's image have PST at the end. Excel will treat this cell as text because of the PST.
On the column, use the Remove/Replace function and put PST to be replaced with (leave it blank).
The date/time will now be recognized by Excel as date/time in the same cell. It can be sorted and formatted to be read as you wish.
We ran a test before we posted to ensure it worked.
Would this work in this case?
have never used, but just now reading, it seems the formula requires a SPECIFIC number of characters, but in this case the data on the left and the right varies.
BETTER than my solution in this case.
Good deduction.
Maybe I missed the point of this thread but the top screenshot is how it comes from Amazon. The bottom is after 2 mins of work to make it make sense / sort. All done with Left / Right function. I split the date from the time, then sort date / time and get the transactions in order, to the second…
Recognizing -8:00 sets time in relation to Greenwich Mean Time …
All you would need to do is
Use Replace function … set T to be replaced (replace all) with a [space]
Use Replace function … set -8:00 to be replaced (replace all) with (empty … leave blank)
The column would now be readable to excel as date / time and sortable.
You could select all 3 date columns and do the two replace functions on all 3 columns at one time
That is a different report. I am working with the Date Range Unified Transaction Report from the Reports Repository (used to be on the payments tab). The date/time is in column A, formatted like this:
(I color-coded it)
I will keep that suggestion in mind, I am familiar with the Remove/Replace function. Sorting the day of month works for me.
It split the date into one column and the time into another, so the PST did not affect the date sort order.
