Previous in Forum: iPhone Nightmare   Next in Forum: How to Find the Area Intersection Between Two 2D Entities in Inventor?
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
3 comments
Rate Comments: Nested
amitabha0107
Power-User

Join Date: Feb 2011
Location: Shimurali, Westbengal,India
Posts: 119

Autoupdated Clock in Excel

03/21/2013 3:20 AM

In excel I write time() function for showing current time. But it can't update with each second automatically. Please send me the process/formula, how I can make a clock which shows current time automaticcaly as I open the Excel sheet.I want to use it with in a sing cell.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
PWSlack
Guru
United Kingdom - Member - Indeterminate Engineering Fields - Control Engineering - New Member

Join Date: Jan 2007
Location: In the bothy, 7 chains down the line from Dodman's Lane level crossing, in the nation formerly known as Great Britain. Kettle's on.
Posts: 32175
Good Answers: 839
#1

Re: autoupdated clock in excel

03/21/2013 4:13 AM

Excel works by recalculating every time a cell changes value. The closest one can get is the =now() function, which will update every time a cell changes value.

__________________
 "Did you get my e-mail?" - "The biggest problem in communication is the illusion that it has taken place" - George Bernard Shaw, 1856
Register to Reply
jack of all trades
Guru
New Zealand - Member - Kiwi Popular Science - Weaponology - New Member Engineering Fields - Power Engineering - New Member Engineering Fields - Electrical Engineering - New Member

Join Date: Sep 2006
Location: Auckland, New Zealand
Posts: 8777
Good Answers: 376
#2

Re: Autoupdated Clock in Excel

03/21/2013 2:50 PM

I am not sure. Perhaps you could write an Excel Macro to do this?

__________________
 jack of all trades
Register to Reply
RAMConsult
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#3

Re: Autoupdated Clock in Excel

03/22/2013 1:03 PM

There's always some yahoo out there that figures these things out. It's nicely detailed there.

__________________
 “Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Register to Reply
Have a Different Question?
3 comments
Copy to Clipboard

Users who posted comments:

jack of all trades (1); PWSlack (1); RAMConsult (1)

Previous in Forum: iPhone Nightmare   Next in Forum: How to Find the Area Intersection Between Two 2D Entities in Inventor?

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (85 right now)
Show Members
Advertisement