View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sasa Stankovic Sasa Stankovic is offline
external usenet poster
 
Posts: 38
Default Date and time in cell

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).

"Grd" wrote in message
...
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