TIME / NOW

[Peo Sjoblom]

=NOW()

format as hh:mm, updates whenever you close/open or calculate the workbook
(you can also press F9)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[andrewd.wallace]

Does anyone know how to
show the current time in cell
so that it updates with the clock time of
the computer???

Thks

ADWallace
UK

 

[Bob Phillips]

If you want it to tick-over, you need some kind of timer. Mail me if you
want an example workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[andrew21]

in D3 i have =NOW() which correctly displays the current time...i wis
to capture the numeric value B3 at a specific time...so in B10 i place
the formula =IF(D3="15,38,00",B3,"") ....but it doesn't work..a
15:38:00 it fails to record the value in B3....how come

 

[Gord Dibben]

andrew

Unless you have a macro that is re-calculating the worksheet continuously, it
would be very difficult to re-calc at the exact time of 15:38:00

You will have to use VBA code to get what you want.

See Chip Pearson's site for methods and code. Specifically the section on
"Using Windows Timers".

http://www.cpearson.com/excel/ontime.htm

Gord Dibben Excel MVP

 

[andrew21]

Gord
yes that is precisely what i have...B3 is continuously changing second
by second and the time in D3 is ticking(presumably in sync with my
computer's time)...so at the precise moment of 15:30:12 (for example)
why couldn't the value in B3 be recorded?...the purpose i have in mind
would be to record this value once or twice a day say at 10:20AM and
3:00PM...it doesn't have to be exact to the second it could be any one
of the values in B3 within 1 minute of the proposed times---since B3 is
a cumulative total and won't increase too much within a 1 minute time
frame
andrew