Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timezone converter
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert GMT date/time to different timezone | Excel Worksheet Functions | |||
converter | New Users to Excel | |||
PDF Converter | Excel Discussion (Misc queries) | |||
Currency Converter | Excel Worksheet Functions | |||
currency converter | Excel Discussion (Misc queries) |