Time Zones & Global Scheduling in Excel: UTC Offsets, DST & Meeting Windows
Convert between UTC and local time, plan meetings across six cities, calculate daylight-saving switch dates by formula, find shared working windows and handover gaps, schedule shifts across midnight, set SLA deadlines with WORKDAY.INTL per region and check a follow-the-sun support rota – 8 hands-on labs at one global software company, every cell checked instantly.
The first 2 lessons are free — no account needed.
Lessons
- UTC Offsets: Local Time from UTC, Offset Labels & the Date LineFree
- One Meeting, Six Cities: Converting via UTC and Testing Working HoursFree
- Daylight Saving Time by Formula: Last Sunday, Second Sunday & the Exact Switch Moment Pro
- Shared Working Windows: UTC Hours, Pairwise Overlap, Handover Gaps & a Common Window Pro
- Shifts Across Midnight and Time Zones: Local Ends, UTC Windows & Coverage at a Moment Pro
- SLA Deadlines Across Time Zones: Local Business Days, Weekend Codes & Closure Lists Pro
- When Do Customers Write? Tickets by Local Hour, Daypart & Weekday Pro
- Capstone: A Follow-the-Sun Support Rota with 24-Hour Coverage Checks Pro