I will [hopefully] be watching the Suzuka Grand Prix and related events live streamed from Sky Sports F1 this weekend..
I started out trying to convert local Suzuka schedule of events times to Guadalajara time, and with the 15 hour time difference Suzuka ahead of Guadalajara, the 7 hour time difference London behind Guadalajara, the question of daylight savings time, UTC time, the near certainty that some of the events will cross the international date line so even my friggin' dates are going to be wrong for some of the events.... Arrrrggghhh!
Can someone here who is smarter than me (i.e., virtually all of you) tell me the London dates/times that Sky Sports will stream the following events:
Free Practice 1 Free Practice 2 Free Practice 3 Qualifying Grand Prix
I can deal with the London --> Guadalajara time conversion.
In case you want to try going down the rabbit hole I tried and gave up on, here are the local Suzuka scheduled times:
FP1 will be 1130 Friday FP2 will be 1500 Friday FP3 will be 1130 Saturday Qualifying 1500 Saturday Grand Prix 2300 Sunday
I THINK that here in Guadalajara
FP1 will be Thursday at 2030 FP2 will be Friday at 0000 (midnight) FP3 will be Friday at 2030 Qualifying Saturday at 0000 (midnight) Grand Prix Saturday at 2300.
but who knows? Hell, I'm retired, I don't even know what month it is half the time.
tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"
Registered: 20/12/1999
Posts: 31597
Loc: Seattle, WA
Your two links seem to contradict each other by one hour. Your first link puts the start at 11pm and your second link puts the start at midnight. I think your first link is right, and the second link is... not "wrong" technically, but, "incomplete" for Doug's purposes.
Daylight Saving time might be the reason for the difference.
I think it might be because both links are showing USA central time, which is related to, but not always the same as, Guadalajara time. If I'm reading my research right, neither Japan nor Mexico observe daylight saving. So USA's current central time would be a correct equivalent to Guadalajara only some of the year, but not the summer months when DST is still in effect (like right now).
So your first link lists the times as "JST" and "CST", the "S" part representing standard, not daylight, times. Your first link puts the race start at 11:00 CST. Which is, I think, good? Since CST (standard, not daylght) is, I think, the same as Guadalajara.
I think the second link is incomplete for Doug's purposes because it lists CDT, daylight time, which is an hour off of Guadalajara at the moment. It's correct if you live in the USA but not if you live in Mexico.
I think. Time zones are fucking confusing. I could have all of that totally wrong.
...the near certainty that some of the events will cross the international date line so even my friggin' dates are going to be wrong for some of the events.... Arrrrggghhh!
And that turned out to be the crux of the problem. My spreadsheet actually did get time times right, but the event times that crossed the international date line between Japan and Mexico showed the wrong date. The snippet of spreadsheet shown below demonstrates the error before it was fixed.
I found and bookmarked a website that greatly simplified things for me. (See screenshots.) I am glad to see that I am not the only one not smart enough to deal with time zones across international date lines!
tanstaafl.
Attachments
Edited by tanstaafl. (22/09/202313:37) Edit Reason: Reduce file size of attachments
_________________________
"There Ain't No Such Thing As A Free Lunch"
I was going to mention the Formula 1 website for the time conversions.
I don't know how Sky does it, but F1 TV (which is awesome) starts the Pre-Qualifying and Pre-Race shows like 30-60 mins before the scheduled time. So I keep an eye on the countdown and start the stream a few mins before the show starts.