Thread: Current Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Current Time

Again ?
It may help if you actually read your replies instead of continually posting
the same question.
If this is because Google is slow sometimes, you should stop using that
interface and use a real news reader:
http://www.cpearson.com/excel/DirectConnect.htm

NickHK


"Akash" wrote in message
ups.com...
Hi,

I had a new requirement this time.... I tried a lot but fail to get
the exact outup in regard to this matter. right Now i am staying in
India and follow (GMT+05:30)Chennai, Kolkata, Mumbai. New Delhi

I have a sheet in which i have to enter current Time in Cell E2 as per
(GMT+05:30). As soon as I enter Current Time in Cell E2 i want the
current time in E6, E7, E8, E9....E18,

E6...... GMT/UTC + 01:00 hour......
A6...Paris---------------------------- C6... France
E7...... GMT/UTC + 00:00 hour...... A7... London
------------------------C7... United Kingdom
E8...... GMT/UTC - 10:00 hour....... A8... Hawaii National Park ----
C8... United States
E9...... GMT/UTC - 08:00 hour....... A9... Hawaiian Gardens----------
C9... United States
E10.... GMT/UTC - 06:00 hour....... A10.. Chicago
-----------------------C10.. United States
E11.... GMT/UTC - 05:00 hour....... A11.. New
York----------------------C11.. United States
E12.... GMT/UTC - 06:00 hour....... A12.. Moscow
-----------------------C12.. United States
E13.... GMT/UTC + 02:00 hour...... A13.. Cape
Town--------------------- C13.. South Africa
E14.... GMT/UTC + 08:00 hour...... A14..
Beijing---------------------------C14.. China
E15.... GMT/UTC + 08:00 hour...... A15..
Singapore----------------------C15.. Singapore
E16.... GMT/UTC + 09:00 hour...... A16.. Tokyo
---------------------------C16.. Japan
E17.... GMT/UTC + 10:00 hour...... A17.. Sydney
-------------------------C17.. Australia
E18.... GMT/UTC + 12:00 hour...... A18.. Queenstown ------------------
C18.. New Xealand

Kindly Help Me in this regards.

Thanks

Akash Maheshwari