Update time

[Ashu]

Dear All,

I have a query in Excel which are as follows:-

I work for Logistic department in Dubai and often we visit Website to
see time of each country we deal with, but recently an idea flashed my
mind that this could be done in excel.

I want to create 3 columns, first with current UAE time, second column
with Country time and third column with difference in time. These 3
columns should be constantly updated automatically, Check this out
pls.

Thanking you in anticipation,


Regards,

Ashu.

 

[Tushar Mehta]

So, what's the question?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Ashu]

Sorry, question is how do i create the above mentioned columns which
should update each column as per the system time.

Trust the msg is clear

 

[masim]

Hi

I dont know how to constantly update the formula....ofcourse Tushar
Mehta would...

try this

In cell A1 write this formula : =NOW()
In cell b1 write this formula : =A1+"05:00:00"

Here +"05:00:00" assums that country time is 5 hrs ahead of ur system
time, for countries that are behind ur system time use - sign.

In cell C1 write this formula : =
=TEXT(IF(B1-A1>0,B1-A1,A1-B1),"hh:mm:ss")


Format cell A1 and B1 as time > hh:mm:ss
and C1 as General

press F9 to update the times.

Regards
Asim

 

[Dave Peterson]

I wouldn't waste the resources to have it update continually. But I would hit
F9 whenever I wanted to see an accurate time.

 

[Tushar Mehta]

Put =NOW() in one cell, say, A1. In another cell, enter the time
difference of interest to you. For example, say in A2, type in 4:00.
In a third cell, enter =A1+A2.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Ashu]

Thanks a lot it is working fine.......as instructed.

This was my first query in this site and i have got the right
solution...hence i will be frequent visitor to this site with lot more
questions coming from my end.

Thanks again,

Ashu.

 

[Tushar Mehta]

The site you are using ExcelTip.com or ExcelForum.com is *not*
providing with any solutions. It simply connects you to the Usenet
newsgroups. You can connect directly to newsgroups. For more, see the
tutorial 'Outlook Express and Newsgroups' on my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions