SpeakUp provides users the option to download data of their Issues overview. If you are not familiar how, please read: How do I download an overview of Issues?
By default your issues export will contain the following dates:
-
Created at
-
Updated at
-
Data retained until
-
Acknowledged at
-
Received at
-
Due date
All dates (except for ‘Data retained until’) are timestamps in ISO 8601 format.
Let’s look at an example:
|
created at |
|
2024-05-22T08:47:27.946Z |
-
2024-05-22: Date in YYYY-MM-DD format, indicating the year (2024), month (May), and day (22nd).
-
T: Separator between the date and time components.
-
08:47:27: Time in HH:MM:SS
format (24-hour clock), representing hours (8), minutes (47), and seconds (27).
-
Z: Indicates the UTC (Coordinated Universal Time) timezone. "Z" stands for "Zulu" time, which is the military name for UTC.
In summary, this timestamp represents May 22nd, 2024, at 08:47:27 UTC.
You can easily convert the timestamps in excel by using the below formula:
=DATEVALUE(LEFT(CELL NUMBER,10))+TIMEVALUE(RIGHT(LEFT(CELL NUMBER,19),8))
You can easily convert the timestamps in excel by using the below formula:
=DATEVALUE(LEFT(CELL NUMBER,10))+TIMEVALUE(RIGHT(LEFT(CELL NUMBER,19),8))
You may see this formula in action below:
Please note that after applying the formula to column A, we formatted column B into a date format so that it becomes human-readable.