VBA state time

[bensonsearch]

Hi All,

I have a project that I need the state times (for Australia) showing at all times. I can get it with the below (and its kept in real time no worries) but is there an easier way to adjust the states esp when daylight savings time comes around? otherwise I need to adjust code constantly as different states do/dont have daylight savings

Dim asd As String
Dim dsa As String
Dim sa As String
 
dsa = Format(time - TimeValue("02:00:00"), "short time")
asd = Format(time, "short time")
sa = Format(time - TimeValue("00:30:00"), "short time")
Home.Label6.Caption = asd
Home.Label5.Caption = asd
Home.Label4.Caption = asd
Home.Label2.Caption = dsa
Home.Label3.Caption = sa

 

[Andrew Poulsom]

This may help you:

http://www.cpearson.com/Excel/TimeZoneAndDaylightTime.aspx