View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dr dr is offline
external usenet poster
 
Posts: 29
Default Is there a way to auto convert a time stamps to Eastern Standard T

I am working with with various time stamps on a log sheet.
I'm handicapped by my limited proficiency with VBA and other UDFs.

What I'm hoping to have is a function that will convert a time stamp to
EST, as opposed to being presented in whatever zone it is logged in.

So, if a person in California time stamps 12:05 PM, it will automatically
add 3 hours when off DST or 4 hours when on DST.

I have a sneaking suspicion I will be at this for a while, just to learn
what I need to know to move forward with it..

Any help is appreciated!