Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 1. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. DRG New Member. Joined Jan 20, Messages Is there a formula to achieve this? I would be very grateful is someone can assist me with this! Excel Facts. Return population for a City.
Click here to reveal answer. If you have a list of cities in A2:A, use Data, Geography. Population and copy down. Joined Jul 12, Messages I feel this really should not be too hard to figure out, so let me help you a hand to get you on your way There are two things we know: 1 There is a fixed difference in time between the two time zones 2 This fixed difference changes in certain periods because of daylight savings time A formula without taking daylight savings into account would simply add the x amount of ours necessary.
However, since you DO want to take daylight savings into account, you need to determine the amount of hours the zones differ during specific periods in the year. This tells you to use IF functions to determine the current date you're working with, with the result of that query being the amounts of hours the zones differ.
Thought of helping your thought process rather than just giving the formula. Hi Tim, Thanks - i found this formula with these parameters: to add 2 hours in summer and 1 hour in winter, g iven that daylight saving starts at on the last Sunday in March and ends at on the last Sunday in October if you have a timestamp, including time and date, in cell G4 this formula will add 1 hour in winter and 2 hours in summer, for any date.
But I need to add 8 hours in summer and 9 hour in winter. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. DRG New Member. Joined Jan 20, Messages Is there a formula to achieve this?
I would be very grateful is someone can assist me with this! Excel Facts. Return population for a City. Click here to reveal answer. If you have a list of cities in A2:A, use Data, Geography. Population and copy down.
0コメント