Does anyone have a cunning method of reformatting the date/timestamps in the csv analytics report exports please?
They currently come out like this…
But we would like them to be more human readable, like this…
We have created a macro in Excel that splits it into separate date and time columns in the format we require, but then merging the two columns just turns the contents into a number (e.g. 44937 0.159224537037037) which we then cannot convert into a meaningful date & time.