G
Guest
Can I convert time in Excel based on BST.
For eample if the time in the UK is 09:00 the conversion would mark
Australia with the appropriate time based on the timezone differnece. Eample
eblow:
Uk time is D2 = 09:00
Australia Time D3 =18:00
is there a way I can populate the UK and it completes the Australia time
automatically via a look up. I have lots of countries to add into the sheet.
Thanks in advance,
Chris
For eample if the time in the UK is 09:00 the conversion would mark
Australia with the appropriate time based on the timezone differnece. Eample
eblow:
Uk time is D2 = 09:00
Australia Time D3 =18:00
is there a way I can populate the UK and it completes the Australia time
automatically via a look up. I have lots of countries to add into the sheet.
Thanks in advance,
Chris