Questions tagged [time-zone]

An Earth region that has a uniform standard time for legal, commercial, and social purposes. In order for the same clock time to always correspond to the same portion of the day as the Earth rotates (for example, the sun being at its highest point every day around noon), different places on the Earth need to have different clock times.

Filter by
Sorted by
Tagged with
0
votes
1answer
44 views

How to get correct TimeZone in googlesheet using script?

I have wrote following script in my google sheet hoping to convert a timestamp in GMT to a customized timezone. function myFunctions(datetimeString,timeZone,format) { var moment = new Date(...
2
votes
1answer
26 views

How do I create multiple time zones by using the NOW formula?

I'm trying to create 5 cells with different time zones: CDT MDT MST PDT EDT I am in MST, so I obviously get my current time by doing NOW() How do I add hours to that? I tried NOW()+(2,0,0) But ...
0
votes
0answers
60 views

Google Calendar TimeZone problem

I use Google Calendar to post events on my website. However, I'm currently in California (PST). If I have an event in Toronto (EST), I'll put it in my Google Calendar at 8pm, but on the calendar on ...
1
vote
2answers
580 views

Google Sheets can't understand timestamp format containing timezone information

GitHub API returns timestamps like so 2018-10-03T10:30:51.444Z which as a programmer is not unusual. But when I put this into a Google sheet cell, it refuses all my attempts to get it recognised as a ...
0
votes
1answer
852 views

How to auto-calculate time based on time zones

What I'm trying to do, is to list out time zones for 24 people. The problem comes in when daylight savings dates trigger, the listed time is no longer correct. Currently, I just have everyone's GMT ...
0
votes
2answers
9k views

How to format the time in this Google Apps Script

I want to format a Google Sheet cell when I read it in my script but it comes out 25 minutes later. The cell's time is 20:00:00 but the output is 20:25. I am using this var formattedDate = Utilities....
1
vote
1answer
1k views

Can I have a Google Forms automatically capture a user's time zone?

I ask because I want to: give users a grid to select days and times they are usually online. They might be anywhere in the world. Eg columns are Mon, Tues, ..., Sun, Rows are Midnight-3am, 3am-6am, .....
0
votes
1answer
175 views

Search for users by timezone or country on Slack?

For example if I wanted to see all users who were in Australia, could I search for them by either a timezone or country?
1
vote
1answer
1k views

How to deal with three different time zones: in Sheets, Google Apps Script and Calendar?

I want to get time with titles from cells (without time zones) and create events in a calendar. Title/Subject Start Times End Times Board meeting 10/22/2017 13:00:00 10/22/2017 14:00:00 Team ...
1
vote
1answer
3k views

How can I adjust Doodle poll time zone?

Doodle assumes that my timezone is Zurich time. Is there any way to change it?
4
votes
1answer
2k views

Set default team timezone in Slack

People are signing into our newly created Slack team with the timezone UTC-7 but we are in UTC+10. I can find where people can manually change their timezone but I am trying to work out how I can ...
3
votes
1answer
332 views

Which country do I select for UTC+0 without daylight saving in Google calendar

In this question, the following image shows a nice selection of GMT+0 without daylight saving. However this option seems to be missing from event timezones. How do I add a UTC time event in google ...
2
votes
1answer
1k views

How to set public Google Calendar embed URL to use client's local time zone?

I've embedded a public google calendar https://www.google.com/calendar/embed?mode=WEEK&src=alecjacobson%40gmail.com This shows the calendar using New York's timezone (my calendar's default), ...
2
votes
1answer
2k views

Specifying time zone in when2meet

Is it possible to specifying time zones in when2meet? I.e. when creating a new event I would like to indicate in which time zone the proposed times are expressed.
4
votes
1answer
319 views

How do I make an event *dependent* on local time in Google Calendar?

I want to create an event that triggers at 0800 local time no matter where you are in the world. In other words, the event will not trigger simultaneously around the world. It will trigger at 0800 EST/...
0
votes
1answer
946 views

How to change google time from EST to IST?

When I search something time related in Google like "when will X telecast","X vs Y" like this, the result shows for EST time. I'm in IST timezone and would like to get the result accordingly. My ...
0
votes
1answer
939 views

Calculating Time Zones in different columns

I'm trying to reflect different time zones across columns. In Excel, I could just e.g., =A1+2 and it would give me the right time. A B C EST CST PST 1 9:30 11:30 13:30 ...
7
votes
1answer
5k views

How to add more than two time zones to Google Calendar?

I need to add 3 if not 4 time zones to my Google Calendar, but I do not see the option for this. What would be the way of achieving this?
2
votes
1answer
75 views

Change the start point of Facebook Page Ads

Facebook says in docs, that Facebook Page Ads always start and end on midnight. In which timezone it is measured? Is there any way I can adjust this to my own timezone (or any other, I like to), to be ...
6
votes
1answer
9k views

To which timezone does the “date” in Gmail refer?

I use Gmail for my email. I do not understand to which point in time the "date" of an email in Gmail refers: is this the local time when/where I received the email, or is it the local time when/from ...
11
votes
2answers
3k views

What time zone are the main GitHub servers located in?

Which time zone is GitHub working from on their servers? For example, a commit made on Sun Dec 2 05:01:00 2012 +0200 is interpreted by GitHub as a commit made on 1st December 2012 in the ...
2
votes
1answer
123 views

Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible? [closed]

I wonder if anyone can explain or reproduce the following test case. It demonstrates that GMT-06:00 Central Time - Tegucigalpa is 668 seconds ahead of GMT-06:00 Central Time, which seems like an ...
0
votes
1answer
440 views

Twitter time stamps an hour off. Returns to normal after browser refresh

Something strange is going on. The newest posts in my feed always appear to be an hour ahead, but when I hit refresh in Chrome the times return to normal. Has anyone experienced this before? Could ...
19
votes
2answers
8k views

Is there a way to set my timezone on github.com?

Whenever I make a comment/issue or commit. The time is off by 10 hours. I believe it is a timezone issue. Is there a way to change my timezone for my github account?
4
votes
3answers
3k views

Is there a way to show Google Calendar events in local time?

AFAICT, in Google Calendar, a calendar has a time zone and an event has a time zone. So you can enter an event and specify that it takes place at, say, 12:00 Eastern Time. If your calendar is also ...
5
votes
1answer
2k views

Why does Google Calendar move events in a different (non-DST) timezone 1 hour backward?

I'm currently residing UTC+3: UTC+2 standard time zone, +1 for daylight saving time (DST). For a trip I'm planning, I'm trying to set a new event in Google Calendar, which takes place in a different ...
4
votes
4answers
166 views

Website for timezone conversion [closed]

I am looking for a website that allows me to convert time between different timezones in an ubiquitous way. Most websites have input restraints that only allow me to type in a specific city or to ...
4
votes
1answer
435 views

What happens to my events when I change my time zone on Google Calendar?

I am currently living in the Pacific US time zone, but I may be doing a summer internship in Eastern time zone, which is 3 hours ahead. What will happen to the existing events when I change my time ...
-1
votes
1answer
518 views

App/API that takes in IP and spits out (longitude,latitude) coords or timezone [closed]

I'm looking for an app or API that allows me to input an IP. The app or API should spit out one of the following things: A coordinate pair (longitude, latitude) A timezone (preferably UTC integer ...
2
votes
1answer
3k views

Google Calendar does not set correct TimeZone

I have an ics file that I'm importing to Google Calendar, and when I go to that Calendar Settings I read: and I specified in ics file the TimeZone in use as: TZID:Romance Standard Time and in all ...
10
votes
4answers
73k views

Why is Gmail showing the wrong date/time for my messages?

Please note that my computer's time is set correctly. Dates and times are correct in all other applications including Google's services such as Google Docs and Google Calendar. However, messages in ...
2
votes
1answer
854 views

Can I get the TripIt calendar to display events (e.g. in google calendar) usually local times?

I've happily added my TripIt calendar to google calendar. Unfortunately, it shows all my flights as beginning and ending at the corresponding local California times. This is useless to me --- I add ...
2
votes
1answer
2k views

Google Calendar all-day reminders not respecting my timezone

I'm using Google Apps Standard Edition, however, I noticed the same exact behavior with my Gmail account as well. At first I thought that reminders are sent at odd times for all-day events, but then I ...
14
votes
7answers
8k views

Convert time zones with Google?

Can I convert time zone calculations (18:30 CEST to GMT+1 for example) with Google?