Trainer explains Excel timezone pitfalls, copy-data-link in UTC, and fixes for field-sample saving errors
Trainer told users the copy-data-link works in UTC to avoid Excel’s automatic timezone conversions, explained techniques in Power Query to keep raw Zulu timestamps, and described a fix to default negative longitudes to prevent 'site not savable' errors when adding field samples.
The full story
During a technical Q&A the presenter clarified how FEMs handles timestamps and how Excel/Power Query can silently convert local station standard time to a user's local time, producing offsets of 6–8 hours when the copy-data-link is used.
Sign up to keep reading.
Your free newsletter brings you what your city council, county, and school board discussed and decided.
or
Free account
Keep reading for free
Create a free account to finish this story and see the video, transcript and key details.
Continue with GoogleContinue with emailAlready have an account? Log in