View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Timezone converter

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