Hi
When exporting the energy tables data to excel the time stamp for each data point is in the wrong format to be viewed?
What do i need to change the format of the cell so i can view the date and time?
Many Thanks
The time stamp in the Excel sheet is the hour of the year, which is what the program uses for calculation. If you want to see the result for a certain date and time of the day you can use the diagram or the table. The table, however, gives mean values for the hour or the chosen time step.
It is also possible to manually recalculate the hour of the year to the date and the time of the day in Excel. Divide the first column by 24 and choose the format YYYY-MM-DD hh:mm or similar under Custom. To get the correct year, you also need to add the number of days since the year 1900. This format does not have Daylight saving time (as ESBO does).
Asked: 2021-12-06 18:33:13 +0000
Seen: 622 times
Last updated: Dec 08 '21
Copyright EQUA 1995-2015. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
