Webinar clock time check
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.
Items to compare
Row 1 is the header. Each item names a session and an audience zone; the invitation text is never read.
No items to compare. That does not mean every invitation is right.
| Row | Session | Zone | Kind | Value | What to compare |
|---|
Converted times for every session
| Row | Session | Zone | Local date and time | UTC offset |
|---|
Notes
- 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.