View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Date and time in cell

=NOW()



"Grd" wrote:

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