How to convert from indian time zone to US time zone

Hi all,

I need some serious help here, not sure if this is possible. I have below Time stamp code.

which inputs current system time, All the system time will be in Time zone of (UTC-05:00) Eastern Time (US & Canada)

i am fine with system inputting this time.


The challenge is, some of the system will be in Time zone of (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi.
Here i need help of Vba code to convert actual Timzone time to (UTC-05:00) Eastern Time (US & Canada) and according to my code
the converted time will be stamped in active cell.


Time zone (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi should be converted to (UTC-05:00) Eastern Time (US & Canada).

my code is as follows,

Please Login or Register  to view this content.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Hi ,

I have attached sample file.

My system time zone is in (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
when i ran my code, it published the current time as 04:59:40 Pm.


I need macro to publish the time in following time zone (UTC-05:00) Eastern Time (US & Canada) always.


If my system time zone is already in Us & Canada time zone, then macro can publish the current time as it is.
If my System time zone is in "(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi" then macro should convert the system time
to "(UTC-05:00) Eastern Time (US & Canada)" and publish the revised time.


So core point is macro should publish only in "(UTC-05:00) Eastern Time (US & Canada)" time zone, current time.

hope i have given details.

If there is 11.5 hours difference between Indian and USA time then an Indian time 4:59:40 PM should convert to a US time of 5:29:40 AM.
So why do you say it should be 7:30:04 AM?

Originally Posted by Logit

.
Could it be because India does not use Daylight Savings Time and the US does ?

Yes it's a possibility and the time difference is 9.5 hours not 10.5. But in practice unless there's something in the data to tell the formula to adjust for daylight saving, unless of course that can be deduced from the date, then I don't see how it can be worked out.

Please Login or Register  to view this content.

Hi Ben and all,

I appreciate each one of your contribution on this.

i have tested the code, it does converts Indian time to US time.

However, if my system time zone is already in US time zone then i dont want any changes in publishing time.
So if my time zone is in Indian standard time then this conversion should happen.

is this possible ?

The following code is from Chip Pearson. Put it in a standard module and run the AAA procedure. You can then use the StandardName variable value in an IF test to determine whether you need to apply the conversion or not.

Please Login or Register  to view this content.

The late, great Chip Pearson - sadly missed on all forums he frequented.