Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert time from one zone to other zone in excel
hi,
just i need to convert time format from one zone to another zone E.g : EST into IST format. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert time from one zone to other zone in excel
=A1+N/24, where N is the number of hourr difference in time zone.
Hence to convert from UTC-5 to UTC+1, use =A1+6/24. -- David Biddulph "ram" wrote in message ... hi, just i need to convert time format from one zone to another zone E.g : EST into IST format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display the time zone in Excel? | Excel Discussion (Misc queries) | |||
How to set a formula to convert the time zone | Excel Worksheet Functions | |||
Time Zone.. | Excel Discussion (Misc queries) | |||
Determining current Time Zone In Excel | Excel Discussion (Misc queries) | |||
How to convert phone area-code to state name and time zone | Excel Discussion (Misc queries) |