how to convert UTC to AEST in Numbers

Question

IND1947 Author

Level 1

8 points

how to convert UTC to AEST in Numbers

Hi,

I am using numbers and want to convert UTC (Date and time) to AEST. Can anyone please help me. Here is an example.

Posted on Mar 12, 2021 6:55 PM

Reply

Answer 1

Top-ranking reply

Yellowbox

Level 7

21,939 points

Mar 12, 2021 9:02 PM in response to IND1947

Hi IND1947,

AEST is 10 hours ahead of UTC. Add "10h" (a duration).

Formula in B2 $A2+"10h"

Regards,

Ian.

Reply

Answer 2

Barry

Level 9

60,023 points

Mar 12, 2021 10:46 PM in response to IND1947

AEST is 10 hours ahead of UTC, so the conversion is just a matter of adding 10 hours to the date & time value in column A.

Making Numbers recognize ten hours in a formula requires presenting the value as a text string ( "10h" ), as is done in the formula in B2, and filled down the column in the example below.

(I see my timing was off, and I caught the insertion point in the shot.)

Regards,

Barry

Reply

Answer 3

IND1947 Author

Level 1

8 points

Mar 15, 2021 2:10 PM in response to Yellowbox

Thanks Barry

Reply

Answer 4

IND1947 Author

Level 1

8 points

Mar 15, 2021 2:11 PM in response to Yellowbox

Thanks Ian,

Reply

how to convert UTC to AEST in Numbers

Similar questions