Tracking Time of different city in comparision to Indian Standared Time

[Akash]

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.. NewYork----------------------
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

 

[kassie]

Hi
Format Col E as Time - 12:00:00
In E 2 enter the time you want to display
I would insert the time difference in one of the open columns, to make
copying easier. You appear to be using col's A, C and E only? In D, insert
the various time differences, eg in D6, enter 1, in D7 enter 0, in D8 enter
-10 and so on.
In E6 enter the following formula
=IF($E$2="","",$E$2+(D6/24))

If you cannot do this, then you will have to write formulae for each row, eg
=IF(E2="","",E2+(1/24))
=IF(E2="","",E2+(-10/24))
and so on

 

[Bob Phillips]

still asking? it is easier to read previous posts believe me

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Akash]

Hi
Format Col E as Time - 12:00:00
In E 2 enter the time you want to display
I would insert the time difference in one of the open columns, to make
copying easier. You appear to be using col's A, C and E only? In D, insert
the various time differences, eg in D6, enter 1, in D7 enter 0, in D8 enter
-10 and so on.
In E6 enter the following formula
=IF($E$2="","",$E$2+(D6/24))

If you cannot do this, then you will have to write formulae for each row, eg
=IF(E2="","",E2+(1/24))
=IF(E2="","",E2+(-10/24))
and so on

--
Hth

Kassie Kasselman
Change xxx to hotmail

It didnt helped me...