Spreadsheet: 876354d1723040680-convert-utc-or-aest-to-local-time-precisely-convert-utc-or-aest-to-local-time
Sheet: CONVERT TO LOCAL TIME

UTC | AEST (+ 10) | AEDT (+ 11) | LOCAL TIME ZONE | LOCAL TIME | DIFF | FORMULA 1 | FORMULA 2
2019-04-06 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-04-06 22:00:00
2019-04-06 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-04-06 23:00:00
2019-04-06 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-04-07 00:00:00
2019-04-06 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-04-07 01:00:00
2019-04-06 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-04-07 02:00:00
2019-04-06 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 02:00:00
2019-04-06 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 03:00:00
2019-04-06 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 04:00:00
2019-04-06 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 05:00:00
2019-04-06 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 06:00:00
2019-04-06 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 07:00:00
2019-04-06 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 08:00:00
2019-04-06 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-04-07 09:00:00
2019-06-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-06-01 22:00:00
2019-10-05 11:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-10-05 21:00:00
2019-10-05 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-10-05 22:00:00
2019-10-05 13:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-10-05 23:00:00
2019-10-05 14:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-10-06 00:00:00
2019-10-05 15:00:00 |  |  | AU EASTERN STANDARD (+10) | 2019-10-06 01:00:00
2019-10-05 16:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 03:00:00
2019-10-05 17:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 04:00:00
2019-10-05 18:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 05:00:00
2019-10-05 19:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 06:00:00
2019-10-05 20:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 07:00:00
2019-10-05 21:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 08:00:00
2019-10-05 22:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 09:00:00
2019-10-05 23:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-10-06 10:00:00
2019-12-31 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2019-12-31 23:00:00
2020-04-04 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-04-04 22:00:00
2020-04-04 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-04-04 23:00:00
2020-04-04 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-04-05 00:00:00
2020-04-04 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-04-05 01:00:00
2020-04-04 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-04-05 02:00:00
2020-04-04 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 02:00:00
2020-04-04 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 03:00:00
2020-04-04 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 04:00:00
2020-04-04 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 05:00:00
2020-04-04 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 06:00:00
2020-04-04 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 07:00:00
2020-04-04 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 08:00:00
2020-04-04 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-04-05 09:00:00
2020-06-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-06-01 22:00:00
2020-10-03 11:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-10-03 21:00:00
2020-10-03 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-10-03 22:00:00
2020-10-03 13:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-10-03 23:00:00
2020-10-03 14:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-10-04 00:00:00
2020-10-03 15:00:00 |  |  | AU EASTERN STANDARD (+10) | 2020-10-04 01:00:00
2020-10-03 16:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 03:00:00
2020-10-03 17:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 04:00:00
2020-10-03 18:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 05:00:00
2020-10-03 19:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 06:00:00
2020-10-03 20:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 07:00:00
2020-10-03 21:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 08:00:00
2020-10-03 22:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 09:00:00
2020-10-03 23:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-10-04 10:00:00
2020-12-31 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2020-12-31 23:00:00
2021-04-03 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-04-03 22:00:00
2021-04-03 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-04-03 23:00:00
2021-04-03 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-04-04 00:00:00
2021-04-03 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-04-04 01:00:00
2021-04-03 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-04-04 02:00:00
2021-04-03 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 02:00:00
2021-04-03 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 03:00:00
2021-04-03 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 04:00:00
2021-04-03 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 05:00:00
2021-04-03 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 06:00:00
2021-04-03 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 07:00:00
2021-04-03 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 08:00:00
2021-04-03 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-04-04 09:00:00
2021-06-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-06-01 22:00:00
2021-10-02 11:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-10-02 21:00:00
2021-10-02 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-10-02 22:00:00
2021-10-02 13:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-10-02 23:00:00
2021-10-02 14:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-10-03 00:00:00
2021-10-02 15:00:00 |  |  | AU EASTERN STANDARD (+10) | 2021-10-03 01:00:00
2021-10-02 16:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 03:00:00
2021-10-02 17:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 04:00:00
2021-10-02 18:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 05:00:00
2021-10-02 19:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 06:00:00
2021-10-02 20:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 07:00:00
2021-10-02 21:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 08:00:00
2021-10-02 22:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 09:00:00
2021-10-02 23:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-10-03 10:00:00
2021-12-31 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2021-12-31 23:00:00
2022-04-02 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-04-02 22:00:00
2022-04-02 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-04-02 23:00:00
2022-04-02 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-04-03 00:00:00
2022-04-02 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-04-03 01:00:00
2022-04-02 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-04-03 02:00:00
2022-04-02 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 02:00:00
2022-04-02 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 03:00:00
2022-04-02 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 04:00:00
2022-04-02 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 05:00:00
2022-04-02 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 06:00:00
2022-04-02 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 07:00:00
2022-04-02 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 08:00:00
2022-04-02 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-04-03 09:00:00
2022-06-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-06-01 22:00:00
2022-10-01 11:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-10-01 21:00:00
2022-10-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-10-01 22:00:00
2022-10-01 13:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-10-01 23:00:00
2022-10-01 14:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-10-02 00:00:00
2022-10-01 15:00:00 |  |  | AU EASTERN STANDARD (+10) | 2022-10-02 01:00:00
2022-10-01 16:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 03:00:00
2022-10-01 17:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 04:00:00
2022-10-01 18:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 05:00:00
2022-10-01 19:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 06:00:00
2022-10-01 20:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 07:00:00
2022-10-01 21:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 08:00:00
2022-10-01 22:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 09:00:00
2022-10-01 23:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-10-02 10:00:00
2022-12-31 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2022-12-31 23:00:00
2023-04-01 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-04-01 22:00:00
2023-04-01 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-04-01 23:00:00
2023-04-01 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-04-02 00:00:00
2023-04-01 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-04-02 01:00:00
2023-04-01 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-04-02 02:00:00
2023-04-01 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 02:00:00
2023-04-01 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 03:00:00
2023-04-01 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 04:00:00
2023-04-01 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 05:00:00
2023-04-01 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 06:00:00
2023-04-01 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 07:00:00
2023-04-01 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 08:00:00
2023-04-01 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-02 09:00:00
2023-06-01 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-06-01 22:00:00
2023-09-30 11:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-09-30 21:00:00
2023-09-30 12:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-09-30 22:00:00
2023-09-30 13:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-09-30 23:00:00
2023-09-30 14:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-10-01 00:00:00
2023-09-30 15:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-10-01 01:00:00
2023-09-30 16:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 03:00:00
2023-09-30 17:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 04:00:00
2023-09-30 18:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 05:00:00
2023-09-30 19:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 06:00:00
2023-09-30 20:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 07:00:00
2023-09-30 21:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 08:00:00
2023-09-30 22:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 09:00:00
2023-09-30 23:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-01 10:00:00
2023-12-31 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-12-31 23:00:00
2024-04-06 11:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2024-04-06 22:00:00
2024-04-06 12:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2024-04-06 23:00:00
2024-04-06 13:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2024-04-07 00:00:00
2024-04-06 14:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2024-04-07 01:00:00
2024-04-06 15:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2024-04-07 02:00:00
2024-04-06 16:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 02:00:00
2024-04-06 17:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 03:00:00
2024-04-06 18:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 04:00:00
2024-04-06 19:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 05:00:00
2024-04-06 20:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 06:00:00
2024-04-06 21:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 07:00:00
2024-04-06 22:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 08:00:00
2024-04-06 23:00:00 |  |  | AU EASTERN STANDARD (+10) | 2024-04-07 09:00:00
2023-01-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-01-15 13:00:00
2023-02-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-02-15 13:00:00
2023-03-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-03-15 13:00:00
2023-04-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-04-15 12:00:00
2023-05-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-05-15 12:00:00
2023-06-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-06-15 12:00:00
2023-07-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-07-15 12:00:00
2023-08-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-08-15 12:00:00
2023-09-15 02:00:00 |  |  | AU EASTERN STANDARD (+10) | 2023-09-15 12:00:00
2023-10-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-10-15 13:00:00
2023-11-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-11-15 13:00:00
2023-12-15 02:00:00 |  |  | AU DAYLIGHT SAVING (+11) | 2023-12-15 13:00:00