Timezone converter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 13 Jun 2007 16:10 GMT

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

Reply to this Message

Peo Sjoblom - 13 Jun 2007 16:21 GMT

Time in excel is fairly easy, one day is 1 and one hour is 1/24 so all you
have to do is subtract or add

you could set yup a vlookup table with different cities and their timezone
and based on that get a value to subtract/add

if you want to add 5 hours to a date and time value in A1 you just do

=A+(5/24)

and format as date and time etc

Signature

Regards,

Peo Sjoblom

> Can I convert time in Excel based on BST.
>
[quoted text clipped - 13 lines]
>
> Chris

Reply to this Message