I have some data with timestamps in this format (The actual timevalue of this is sometime in October or November of 2020):
.
I've found this formula and have tried to modify it to read my data, but so far, no luck (Where A1 is the raw data number):
Also I've tried this without success.
I'm pretty sure the data is in UTC but regardless of time zone, whatever formula can "read" this format should work.
(Note: I did not attach a workbook since this is a single formula question. Hope this is OK).
Any thoughts? Thanks.
Bookmarks