current time

[alain dhaene]

Hi,

simply question (i think)

Wich function must I use to get the current time?

So the result must be : 11:01

Thx,

 

[JE McGimpsey]

The current time can be input to a cell using

CTRL-SHIFT-;

If you want a function that will update whenever the sheet is
calculated, use

=NOW()

for the current date and time or

=MOD(NOW(),1)

for just the time.