| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUP Problem with Time Comparision | Excel Discussion (Misc queries) | |||
| Time Tracking Help | Excel Discussion (Misc queries) | |||
| Tracking Time | Excel Worksheet Functions | |||
| Tracking Time | Excel Discussion (Misc queries) | |||
| Time tracking | Excel Programming | |||
Hybrid Mode
