Question
I've exported a filtered Activity Log into a CSV file and when I open it I only see a timestamp for each Activity Log record. How can I get a date instead of a timestamp there?
Answer
For example, your timestamps are located in column A and A1 is a column title "timestamp". Create a new column, name it "Date/Time" and set values there by the formula:
=((A2-21600000)/86400000)+date(1970,1,1)
Then format the value to Date/Time.
Comments
Please sign in to leave a comment.