Function to be added on timestamp Macro to align time of users from different time zones

[Maxence]

Hi,
I am looking for a function to convert time given by my computer (Local time) in EST (Eastern Standard Time).
We are several users of a same file (with timestamp macros) and all time need to be aligned to one time zone (EST), even if all users are working in different time zone (EST, CST and IST).

[foundy]

Hi, I did something similar a while ago, which I can't find but I got a lot of help from Chip Pearson's site

http://www.cpearson.com/excel/TimeZo...lightTime.aspx

This use an API to find GMT & Day light saving, from there you should be able to figure out EST.