Arduino Cloud Historic Data CSV Excel Sheet

The Time mentioned inside The Historic Data sheet which I received via email from Arduino Cloud is not actual time at with that values are taken from the Sensor.

2024-04-24T03:54:49.980772039Z 0
2024-04-24T04:06:42.775899063Z 1
2024-04-24T04:21:32.763127346Z 2
2024-04-24T04:23:00.171127058Z 0
2024-04-24T04:30:08.424300712Z 1
2024-04-24T04:39:43.775335547Z 2
2024-04-24T05:08:44.69764602Z 3
2024-04-24T05:21:57.979601822Z 4
2024-04-24T05:29:41.589812623Z 5
2024-04-24T05:37:04.555876365Z 6
2024-04-24T05:47:41.686354576Z 7
2024-04-24T05:54:44.876015698Z 8
2024-04-24T06:00:58.375682667Z 9
2024-04-24T06:08:05.986004732Z 10
2024-04-24T06:16:06.428312558Z 11
The Actual Time was 08:50 am for value 0 but the time in the sheet is not correct

probably that all timestamps are stored in UTC and you are not in that timezone ?

I confirm @J-M-L's postulation. The "Z" suffix on the timestamps is the standard designator for the UTC time zone:

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.