Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 25th 07, 10:30 AM posted to microsoft.public.excel.worksheet.functions
Ram Ram is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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.



  #2   Report Post  
Old April 25th 07, 01:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 01:43 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017