Please make sure that the time zone of your spreadsheet matches your actual location. Otherwise, you might experience problems with scheduled updates.
- Go to "File" at the top
- Choose "Spreadsheet settings" here you can change the Locale and also the Time Zone
- If you had choose the right settings click on "Save settings"