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.
38
questions
0
votes
1
answer
101
views
How can I Convert date from 'Mon Jun 05 2023 00:00:00 GMT+0100 (British Summer Time) to 'DD-MM-YYYY' in google APP Script
function onOpen() {
const ui = SpreadsheetApp.getUi();
const menu = ui.createMenu('TRIGGER');
menu.addItem('create new doc' , 'createNewGoogleDocs');
menu.addToUi();
}
function createNewGoogleDocs(...
1
vote
2
answers
117
views
How to find and select a time-zone in Google Calendar create event
When interactively (not programmatically) creating an event in Google Calendar, I can click on the time-zones link to see a list of 100s of time zones. However, I don't see any way (at least in Mac ...
- 111
2
votes
0
answers
851
views
What system Google Photos use to determine the time zone for photos?
When I upload some photos, the following happens depending on the source of the picture:
From my cell phone, it uploads the correct timezone as it is set on the phone when taking the picture (makes ...
- 121
1
vote
1
answer
24
views
I have the formula I want to use but now sure how to change it with time another time zone
I have a formula setup that I want to use. But I have a separate sheet that I want to use in a different time zone. The one I have written is in EST. but I want another sheet to use the same formula ...
- 11
2
votes
1
answer
850
views
How to import an iCalendar event with diferent time zones
On Google Calendar I'm able to manually create an event that starts and ends in different time zones:
I would like to recreate entries like this using the import feature in Google Calendar ((gear) &...
- 123
0
votes
1
answer
1k
views
How to get correct TimeZone in googlesheet using script? [closed]
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(...
- 105
2
votes
2
answers
997
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 ...
- 23
1
vote
2
answers
3k
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 ...
- 508
0
votes
2
answers
6k
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 ...
2
votes
2
answers
40k
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....
- 21
1
vote
1
answer
5k
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, .....
- 429
0
votes
1
answer
1k
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?
- 158
1
vote
1
answer
3k
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 ...
- 11
1
vote
1
answer
11k
views
How can I adjust Doodle poll time zone?
Doodle assumes that my timezone is Zurich time.
Is there any way to change it?
- 237
4
votes
1
answer
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 ...
- 161
4
votes
1
answer
543
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 ...
- 391
4
votes
2
answers
4k
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), ...
- 141
3
votes
1
answer
17k
views
Specifying time zone in when2meet
Is it possible to specify 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.
- 16.9k
4
votes
1
answer
497
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/...
- 41
0
votes
1
answer
1k
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 ...
0
votes
1
answer
1k
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
...
8
votes
1
answer
10k
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?
- 211
2
votes
1
answer
89
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 ...
- 2,638
7
votes
1
answer
14k
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 ...
- 223
12
votes
2
answers
4k
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 ...
- 1,466
2
votes
1
answer
131
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 ...
- 3,104
0
votes
1
answer
479
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 ...
- 165
26
votes
3
answers
15k
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?
- 489
4
votes
4
answers
5k
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 ...
- 299
5
votes
1
answer
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 ...
- 528
4
votes
4
answers
169
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 ...
- 429
4
votes
1
answer
494
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 ...
- 143
-1
votes
1
answer
524
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 ...
- 17
2
votes
1
answer
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 ...
- 223
11
votes
4
answers
111k
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 ...
- 477
2
votes
1
answer
925
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 ...
- 171
2
votes
1
answer
3k
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 ...
- 30.6k
14
votes
7
answers
8k
views
Convert time zones with Google?
Can I convert time zone calculations (18:30 CEST to GMT+1 for example) with Google?
- 668