Tracking Time of different city in comparision to Indian Standared Time
 

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

Tracking Time of different city in comparision to Indian Standared
 

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


"Akash" wrote:

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

Tracking Time of different city in comparision to Indian Standared Time
 

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" wrote in message
oups.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.. 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

Tracking Time of different city in comparision to Indian Standared
 

On Jul 20, 11:38 am, kassie wrote:
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

"Akash" wrote:
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

It didnt helped me...