VBA to convert UTC date to Australian Eastern Standard Time (AEST)

[Deutz]

Hi and thanks in advance,

I would just like to check that my understanding of this is correct before writing some code to convert a UTC date/timestamp in Excel to a date in Australian Eastern Standard Time (AEST).

As I understand it:

1. Add 10 hours to the UTC date

2. Write some functions to get the start and end dates for daylight savings.

3. If the converted date falls within the daylight savings period then add 1 hour to the converted date.

Does that sound correct?

Kind regards
Deutz

 

[Artik]

Does that sound correct?

Yes.
From what I read, daylight saving time is not in effect in the state of Qeensland, while it is used in the southern states.

Artik

 

[Deutz]

Yes.
From what I read, daylight saving time is not in effect in the state of Qeensland, while it is used in the southern states.

Artik

Thanks Atrik for confirming I am on the right track and the Queensland info.

Cheers
Deutz