current time

  • Thread starter Thread starter alain dhaene
  • Start date Start date
A

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,
 
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.
 
Back
Top