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



--
Regards,

Peo Sjoblom


"Chris" wrote in message
...
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