Skip to main content

Hi,

Does anyone have a cunning method of reformatting the date/timestamps in the csv analytics report exports please?


They currently come out like this…

2023-01-11T03:49:17+00:00


But we would like them to be more human readable, like this…

11-01-2023 03:49:17


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.


Thanks

Chris

Hi Chris,


You can use the following cell formula to take the ISO8601 format put it in a simple date & time format

=DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8))

You then just need to make sure the cell format containing the formula is in its desired format, e.g.

image

Thanks very much for this James - that’s done the trick! 👍

Reply


Terms & ConditionsCookie settings