View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default how do i check system time zone from excel?

On Wed, 13 May 2009 12:59:10 -0400, "Rick Rothstein"
wrote:

Note that the TimeZoneBiasInMinutes is the number of minutes adjustment from
Greenwich Mean Time. Normally, this is specified in hours, so if you want it
that way, just divide by 60.


I know you wrote "usually" but a caveat is that all time zones are not exactly
in increments of 60 minutes from UTC. Some are 30 and I believe there are 15
and 45 minute offsets also, in some locales.
--ron