Function Help - take UTC time and make it local automaticaly

[ajscott911]

here's the last issue I'm hoping someone will have an answer for.

in Javascript DateVar.setUTCFullYear(*datecoding*) will set the DateVar to the current users time {based on the users time zone} assuming that *datecoding* is the current time UTC ((IE. if it were noon UTC time it would be 7am Eastern time because Eastern time is -5 hours behind UTC))

Is there a way to do the same thing in VBA without making your own function or barring that, what would an appropriate function look like? I'm trying to make this all automatic without any input from the user telling the function which timezone they are in.

if someone could come up with a custom function that took in an UTC date and fed out a converted time to the users current time zone it would be very helpful.

Adam

 

[Emjaye]

I may be missing the point, as most folkf tend to have their PC time set to local, the =NOW() function should work.
It will display the date and time by default, you may need to change the number format to (custom) hh:mm:ss

The drawback is that it only updates when another calculation takes place... i.e. if you open the workbook at 19:22pm then that is what the function will tell you, even 5 minutes later unless the book or sheet is changed (with a calculation).

You could create a timer using VBA but it would need to refresh every second or minute etc

 

[tusharm]

Searching google led to http://vbnet.mvps.org/index.html?code/locale/index.html

 

[ajscott911]

hmmm. Must have missed that page before in my searches. Thanks a lot, this worked perfectly

Adam