Time Zones: Please post yours!

Let's play a let's play in the let's play forum.
Post Reply
User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Time Zones: Please post yours!

Post by random980 » 28 Sep 2013, 13:18

Having a Let's Play team from all over the world, there is of course going to be the problem of time-zones.
In order to work around this problem we need everyone in the Let's Play gang to post their name, timezone name and UTC/GMT difference in this thread, then i can make a table and upload it bellow. Google doco here:
https://docs.google.com/spreadsheet/ccc ... sp=sharing

Get postin editin :D
Last edited by random980 on 29 Sep 2013, 13:07, edited 2 times in total.
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
RobipodSupreme
Retired
Posts: 1445
Joined: 26 May 2011, 10:30
Contact:

Re: Time Zones: Please post yours!

Post by RobipodSupreme » 28 Sep 2013, 15:52

GMT

UTC +- 0
Last edited by RobipodSupreme on 29 Sep 2013, 05:51, edited 1 time in total.
I'm like 80% gayer than when I was on here last
I was a mod once
my discord is Ryin ❄#4444 if you wanna hmu fams
Miss you :(

User avatar
motormaniac
Retired
Posts: 680
Joined: 23 Oct 2011, 17:17
Location: Georgia, US

Re: Time Zones: Please post yours!

Post by motormaniac » 28 Sep 2013, 17:18

US EST
Image
Image

User avatar
Wildwill002
Posts: 3162
Joined: 15 Dec 2010, 12:42
Location: Blackpool

Re: Time Zones: Please post yours!

Post by Wildwill002 » 28 Sep 2013, 17:32

GMT
Image
Spoiler! :

Code: Select all

            ,             ,
           / '.         .' \
          /    '.     .'    \
           '-._  '. .'  _.-'
               '-. ; .-'
              _.-;(_);-._
          _.-'   .'_'.   '-._
          \    .'/[+]\'.    /
           \_.' /     \ '._/
                |  _  |
                | [_] |
               /III III\
               `"""""""`

User avatar
Spyboticsguy
Posts: 1204
Joined: 22 Jul 2011, 13:22
Location: Atlanta, GA

Re: Time Zones: Please post yours!

Post by Spyboticsguy » 28 Sep 2013, 18:00

EST.
Image

User avatar
Invunarble
Site Contributor
Posts: 4201
Joined: 11 Feb 2012, 18:45
Location: Canada

Re: Time Zones: Please post yours!

Post by Invunarble » 28 Sep 2013, 20:53

Spyboticsguy wrote:EST.
Image
"The roses are red, but Invunarble is blue. Hit him with a puma." - Vallorn
Image
"Baked fucking potato" - Lord Mountbatten, 2014

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 29 Sep 2013, 05:47

Remind other Let's Players to post theirs, or if you know theirs post for em.
(and please add your UTC difference like i asked >.<)

Also Invun, are you even part of the Lets Play group? I ask as your name isnt on the "games i own" table.
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
TEKNOVIRUS
Retired
Posts: 259
Joined: 03 Dec 2011, 19:15
Location: Tirol, Austria

Re: Time Zones: Please post yours!

Post by TEKNOVIRUS » 29 Sep 2013, 06:30

UTC/GMT +1 hour
Patbutalsorick in-game

User avatar
Thelepearchauns
Retired
Posts: 248
Joined: 24 Mar 2012, 12:39
Location: End of a Rainbow
Contact:

Re: Time Zones: Please post yours!

Post by Thelepearchauns » 29 Sep 2013, 09:09

EST
Lep
____________________________________________________________________
Image
____________________________________________________________________
So its a sword that acts like a key in very specific situations
Or its a key all the time...and when you stick it in someone, it unlocks their death
-Church and Caboose

User avatar
shaunpat99
Retired
Posts: 250
Joined: 06 Jun 2012, 17:15
Location: Illinois

Re: Time Zones: Please post yours!

Post by shaunpat99 » 29 Sep 2013, 09:16

That games table has several people on there that are no longer interested, and it's missing a couple of our current people.. I haven't removed them because it's still fairly useful information if they ever decide to join up again.

Here's my timezone: CST, UTC - 6
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 29 Sep 2013, 11:55

Fair enough.
Also how do i upload the table so everyone can see AND edit it? Like the "Games you have" one?
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
shaunpat99
Retired
Posts: 250
Joined: 06 Jun 2012, 17:15
Location: Illinois

Re: Time Zones: Please post yours!

Post by shaunpat99 » 29 Sep 2013, 12:39

If it's a Google spreadsheet, there should be a setting when you save it, something along the lines of "Anyone can view or edit this document." Select that instead of sharing it with email addresses.
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.

User avatar
minnerthecat
Retired
Posts: 604
Joined: 21 Jul 2011, 21:58
Location: Canada

Re: Time Zones: Please post yours!

Post by minnerthecat » 29 Sep 2013, 12:41

Canada, CST -6 hours
Orange and white, but not quite right.

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 29 Sep 2013, 13:12

Oh the wonders of Google.
Now you can all add it yourselves! :P
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
Invunarble
Site Contributor
Posts: 4201
Joined: 11 Feb 2012, 18:45
Location: Canada

Re: Time Zones: Please post yours!

Post by Invunarble » 29 Sep 2013, 13:45

random980 wrote:Also Invun, are you even part of the Lets Play group? I ask as your name isnt on the "games i own" table.
Eh, I thought all of our Civ sessions made me a qualifiable Let's Player by now.

I haven't bothered initially to put my own column in on that spreadsheet because of the fact I assumed I wouldn't be doing anything in this - not to mention the spreadsheet's a bit sloppy now with all those columns :P. I could still fill it in with the games I own though, if need be.
Image
"The roses are red, but Invunarble is blue. Hit him with a puma." - Vallorn
Image
"Baked fucking potato" - Lord Mountbatten, 2014

User avatar
aeroeng15
Retired
Posts: 472
Joined: 26 Mar 2012, 09:55
Location: Cincinnati, Ohio

Re: Time Zones: Please post yours!

Post by aeroeng15 » 29 Sep 2013, 13:47

random980 wrote:Oh the wonders of Google.
Now you can all add it yourselves! :P
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
Select column headers >>> Data -> Sort Range and select how you want it to sort.

I would suggest a lookup table for the TimeZone -> UTC conversion

(I can do said things if needed)

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 29 Sep 2013, 15:26

aeroeng15 wrote:
random980 wrote:Oh the wonders of Google.
Now you can all add it yourselves! :P
If anyone knows how to make the spreadsheet automatically sort by "column B" Z>A and then "column A" A>Z automatically AND go "If B2=GMT, than make C2=O" Than PLEASE by all means add it and tell me how >.>
Select column headers >>> Data -> Sort Range and select how you want it to sort.

I would suggest a lookup table for the TimeZone -> UTC conversion

(I can do said things if needed)
I did the sort range thing, but when new entries are put in, it still doesn't automatically sort/correct the data.
I dont really understand how to make a lookup table or what it will actually do. So can you please sort that out :P
I just want "UTC" to auto-fill when data in Timezone is put in.
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
aeroeng15
Retired
Posts: 472
Joined: 26 Mar 2012, 09:55
Location: Cincinnati, Ohio

Re: Time Zones: Please post yours!

Post by aeroeng15 » 29 Sep 2013, 19:43

I wrote a quick auto-update script, which will sort by UTC descending and then player name.

The lookup table is off to the right and can be expanded as necessary.

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 29 Sep 2013, 20:20

Awesome, thanks for that!
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
shaunpat99
Retired
Posts: 250
Joined: 06 Jun 2012, 17:15
Location: Illinois

Re: Time Zones: Please post yours!

Post by shaunpat99 » 29 Sep 2013, 21:21

Thanks to you both. I have also added two other columns for Time Availability: Weekdays and Weekends. Please put info there as well, I would prefer it in Server Time (CST), but you can go ahead and put it in your timezone and I can convert it. This just needs to be a simple approximation of when you're available to play. This is pretty much for me so I can set you up in teams with like schedules. You can see mine for an example.
Hey you, go check out the Escapecraft Youtube Channel!
"You can't just jetpack away from all your problems!"
But he totally could, and it was awesome.

User avatar
andy25100
Retired
Posts: 656
Joined: 01 Jul 2011, 18:40
Location: Old York

Re: Time Zones: Please post yours!

Post by andy25100 » 04 Oct 2013, 09:48

GMT.
"They'll tear you apart, bone by bone... ...and build with you a human throne. Their buck- toothed king will sit upon What once was you, but now is gone. This key unlocks the gates of Hell. Steady traveler, use it well." - Grim Fandango - Poem of the Flaming Demon Beavers
Image

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 06 Oct 2013, 01:19

Added a new column, DLS (daylight savings) As parts of Australia just started daylight savings. Remember to add another +1 UTC when working out timezones with DLS being observed. (so AEST is now +11 hours UTC >.<)
And remember to keep the column up to date when need be.
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
vallorn
Posts: 8839
Joined: 13 Nov 2010, 10:45

Re: Time Zones: Please post yours!

Post by vallorn » 06 Oct 2013, 13:33

PST (GMT:-8)

Bloody hell west coast ya'll.
Lord_Mountbatten wrote:I didn't quite hear you over the sound of my eyebrow shooting into the sky.
Image
OI YOU!
YES YOU!
WE HAVE A STEAM COMMUNITY GROUP!
JOIN US AND ADD PEOPLE FOR FUN TIMES!

CUT: Baldrick

User avatar
random980
Posts: 1852
Joined: 23 Feb 2011, 03:32
Location: Australia, Vic

Re: Time Zones: Please post yours!

Post by random980 » 07 Oct 2013, 00:20

vallorn wrote:PST (GMT:-8)

Bloody hell west coast ya'll.
I thought you were GMT? Being from England?
http://www.youtube.com/watch?v=XfR9iY5y94s
Eekum Bokum
Sti_Jo_Lew wrote:Random just won the thread. We should all just give up.

User avatar
vallorn
Posts: 8839
Joined: 13 Nov 2010, 10:45

Re: Time Zones: Please post yours!

Post by vallorn » 07 Oct 2013, 14:00

I moved from Blighty to cali a year ago lol
Lord_Mountbatten wrote:I didn't quite hear you over the sound of my eyebrow shooting into the sky.
Image
OI YOU!
YES YOU!
WE HAVE A STEAM COMMUNITY GROUP!
JOIN US AND ADD PEOPLE FOR FUN TIMES!

CUT: Baldrick

Post Reply

Who is online

Users browsing this forum: No registered users and 61 guests