View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Date and time in cell

=NOW()


--


Regards,


Peo Sjoblom



"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