Date and Time Sort MM/DD/YYYY H:M:S AM Format

Originally Posted by daffodil11

Whoops.

=SUBSTITUTE(A1,"(UTC+0)","")*1

Copy, paste values, then format the results as date, and sort as normal.

(The results will be 41671 etc, which is Excel date number stuff. Format to make it look pretty)

Thank You! This worked perfectly!