How to deal with ISO8601 time string in Excel?

8/18/2025

Often timestamp data in DataHub is provided as UTC datetime string according to the international ISO8601 standard.

To convert a ISO8601 UTC datetime string to NZST in excel this formula can be used:

=DATEVALUE(LEFT(A2,10)) + TIMEVALUE(MID(A2,12,8)) + TIME(12,0,0)

The Excel "Format Cells ..." function can be used to display data in different ways: