Can I read GMT and Local Time in Excel Data on EtoBox?

GMT and Local Time in Excel Data by Anonymous QucKa3TCBN is a document available to read on EtoBox.

What is GMT and Local Time in Excel Data about?

The document discusses how date and time are stored and displayed from historical data collected by the Continuous Historian. It can present timestamps in GMT, local time, or with a GMT offset. When viewed in Excel, dates are stored as serial numbers and times as decimal fractions. Converting between GMT and local time can cause issues when daylight saving time is in effect, as the length of a day may change. Reports showing data over a single day need to account for these differences to avoid missing or du

Author

Anonymous QucKa3TCBN

Language

EN