Time in Spread Sheets

**casper69** · 01-26-2009, 12:48 PM

Hi All
I was wondering if there is any formulas for putting a working clock on an excel spread sheet so that its on view all the time and works like a normal clock?

Thanks Guys

casper69

**martindwilson** · 01-26-2009, 02:11 PM

theres vba which will put time in a cell is that what you mean?
in a standard module

Please Login or Register  to view this content.

then in this workbook

Please Login or Register  to view this content.

this will put date /time in c4/c3 of all sheets. but it is not very efficient as its constantly running /updating i tried to pin it to one sheet but then thats all it does it jumps to that on every update. there must be a better way

**shg** · 01-26-2009, 02:35 PM

I was wondering if there is any formulas for putting a working clock on an excel spread sheet so that its on view all the time and works like a normal clock?

IMO, that's a very bad idea. For one thing, it kills Undo. What's wrong with the clock on the taskbar?

**casper69** · 01-26-2009, 03:24 PM

Hi
What i am after is a set up like you would do with the date.

something that looks like: 12:54:01 PM

Regards

casper69

**Shijesh Kumar** · 01-26-2009, 03:26 PM

Hi,

I wonder why nobody suggested

=NOW()

Worksheet function.

**casper69** · 01-26-2009, 03:40 PM

Hi

=NOW()

Brings the current time in but as the minutes pass by the clock dont change

Regards

Ps, there is nothing wrong with the time in the task bar at all i just wondered if it is possible to put a working clock in a spread sheet?

casper69

**martindwilson** · 01-26-2009, 08:23 PM

ok try this add-in download an extract to a folder. then use tools add ins and select tm digital clock
as i have no idea where to do this in 2007 good luck!
http://www.tushar-mehta.com/excel/so...ital_clock.htm