Ask Your Question

Revision history [back]

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).