Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Current 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.. 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Programming | |||
Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
Current time Current date. | Excel Programming |