Time is Strange

How to adjust time zone settings in Google Sheets

Time Zones in Google Sheets

thumbnail with caption, Time…is strange

Since last we spoke I’ve…

  1. Run 40 miles up and down Boring Road 

  2. Built an open source memory verse website 

  3. Hung Christmas lights at our house 🎄🎄

Now to the sheets…

Time Zone Settings

You can get into trouble with time in Google Sheets. There are a couple of time zone settings to adjust if you are having issues with time related functions (yeah, more than one…)

#1 Settings

The first place is for the whole sheet. Just select File - Settings and you’ll see the dropdown selection for time zones.

screenshot of Google Sheets settings

#2 Apps Script Settings

The second place is in Apps Script. You may still have issues if you’re using Apps Script.

Go to Extensions - Apps Script. Then select Project Settings from the left hand bar.

Weird, right? Separate time zone settings for the sheet and the Apps Script.

screenshot of Apps Script Settings

When is this an issue?

This will usually become apparent when sharing with folks in other time zones, and I came across the issue when I had viewers reach out about a Sheets to Calendar Apps Script video I did.

The video walkthrough I did is below 👇

Thank you so much!

It means a lot that you’ve read this, and I hope it’s informed and/or entertained you for a few moments today!

Would love to say hi. Here are the best places to find me:

✉️ LinkedIn
📺️ YouTube

Ways I can help:

  • Find all my video tutorials and walkthroughs on my YouTube channel.

  • View my spreadsheet and creative products on my Gumroad store.

  • Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems.

  • Hire an expert to help complete your next Google Sheets, Apps Script or Google Workplace project.


or to participate.