A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

convert time from one zone to other zone in excel



 
 
Thread Tools Display Modes
  #1  
Old April 25th 07, 10:30 AM posted to microsoft.public.excel.worksheet.functions
Ram
external usenet poster
 
Posts: 138
Default 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.


Ads
  #2  
Old April 25th 07, 01:24 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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.
>
>



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display the time zone in Excel? RW Excel Discussion (Misc queries) 1 October 17th 06 04:20 PM
How to set a formula to convert the time zone Calculate Date range Excel Worksheet Functions 1 April 20th 06 08:47 AM
Time Zone.. Trevor M Excel Discussion (Misc queries) 1 April 10th 06 08:49 AM
Determining current Time Zone In Excel Shaun_C Excel Discussion (Misc queries) 2 April 7th 06 06:29 PM
How to convert phone area-code to state name and time zone NoYouShmoopie Excel Discussion (Misc queries) 2 October 7th 05 02:38 PM


All times are GMT +1. The time now is 03:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.