Timezone Planner
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: