Try it: check webinar clock times for every audience time zone

This is the working version of the webinar clock time tutorial. It reads a CSV schedule of sessions, converts each start time into the time zones your audience is in, and lists items to compare with the invitations: labels on your own list, clock times that do not exist or happen twice on a clock-change day, sessions whose local time or local date shifts for one zone, and starts at odd hours. It never changes your file.

The odd-hours window, the list of labels to flag, the table of zone abbreviations and the usual-time rule are this tool's own settings, not standards. The page uses the time zone data in your browser, so it cannot know a rule change published after that data was built; confirm a doubtful zone against an official source. The sample file is made up for teaching.

Settings you can change

Audience time zones (comma separated)Names like America/New_York

Labels to flag (comma separated)Your own list, matched against the label column

Earliest local start (HH:MM)24-hour clock, for example 07:00

Latest local start (HH:MM)24-hour clock, for example 21:00

Your schedule CSV file from your computer The first row must hold these columns: session_id, series, title, date (YYYY-MM-DD), start (HH:MM in the host zone), host_zone (a name like America/New_York), label.

Items to compare

Row 1 is the header. Each item names a session and an audience zone; the invitation text is never read.

How this lab works

It lists and does not fix. The page never edits your file or writes a corrected one. A person compares each item with the invitation and fixes the schedule or the invitation.
It reads columns, not invitations. The check sees the label column, not the text of an invitation, so a wrong time written only in the invitation text goes unseen.
A short list is not a clean bill. A schedule can be wrong in ways the check does not look for.
The usual time is a rule of ours. It is the most common local time among sessions with the same series, host zone and host start time, and the earliest session wins a tie.
The zone list is yours. Any name your browser knows works. The odd-hours window and the labels to flag are settings, and the table of zone abbreviations is a fixed table of ours.
The download copies cells from your file. A value that starts with an equals sign, a plus sign, a minus sign or an at sign gets a leading apostrophe in findings.csv so that a spreadsheet program does not run it.
It reads one CSV file of up to 2 MB. It does not read workbook files, and the table and the download list the same items.

Starter kit

The starter kit holds this page to run on your own computer, the same check as a script, the made-up sample files, a blank template for your schedule and a change log. Free with your email through the form below; the download link appears after you subscribe.