excel - How to get timestamp of a remote country in VBA? -

i want timestamp of different country in vba. there direct function or way it? example, in india working mexico , want task based on mexican time. able splitting timestamp , manipulating not consider daylight saving in it. there simple solution writing big user-defined function?

know time zone offset & client's time zone offset, use calculate difference

dim indiatz single   dim mexicotz single dim mytime date dim utc date dim mexicotime date  indiatz = 5.5 mexicotz = -4 'note assumes they're in eastern time,  'mexico covers central, mountain & pacific @ -5, -6 & -7.  'you'll need figure out 1 need.  mytime = 'need invert offset india utc utc = datediff("h", mytime, indiatz * -1) 'need invert offset utc mexico mexicotime = datediff("h", utc, mexicotz * -1)