Date and time in cell

[Guest]

Hi there,

I need a way of getting the latest date and time in a cell without having to
manually update it every minute!

I can't see to figure out how to do this. I need something like currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

 

[Peo Sjoblom]

=NOW()


--


Regards,


Peo Sjoblom

 

[Guest]

Does =Now() do what you want?

 

[Guest]

=NOW()

 

[Sasa Stankovic]

you need something like clocks on the internet? real time clock?! If so,
you'll need some VBA, if not =now() should do the job (as already
mentioned).

 

[Guest]

Perfect

Thanks

=NOW()


--


Regards,


Peo Sjoblom