Profile PictureDave Stewart

Indie coder from London, UK

Timezone Planner

$20
0 ratings

Product

Timezone Planner is a Google Sheet which interactively visualises your remote team members' timezones and availability.

Its highly visual design makes it ideal for checking "at-a-glance" who is available and what time it is in their world. And because it's just a spreadsheet, means you can add your own customisations such as columns, links, grouping, filtering etc.

The real magic is the sheet's advanced formulas, timezone calculations, and conditional formatting which transparently factor in location, timezone offsets, local time, available days, working times, overnight hours, even daylight saving time calculations, then rebuilds the sheet in relation to the team member's current timezone (it even updates every minute!).

This sheet will help you to:

  • understand who is working and when
  • modify your day to align or overlap with others
  • work out the best time to schedule meetings
  • keep on top of your co-workers or employees

Buy it once, keep it open in a browser tab, and get the entire team on the same page 🚀

Demo

The following is a demo sheet, so you can see how it looks:

It's had all interactivity removed, but the formatting and structure remains so you should help you understand how it works. Hover over the comments for context!

The full product is fully-interactive, and uses scripting, formulas and conditional formatting to render everyone's availability from the context of the timezone of the current viewer.

More info

For full product information, see the product's home page at:

I want this!

30-day money back guarantee

Just don't be a dick about it, and nor will I 😁

Last updated Apr 25, 2024

Planner
Google Sheet with formulas and formatting
Instructions
Guide on how to set up your team
Copy product URL