View Single Post
  #1   Report Post  
Old March 18th 07, 10:45 PM posted to microsoft.public.excel.misc
Cheese Cheese is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 7
Default NOW() function that is un-changing

Is there a =NOW() type of function that records the "now" time of when I
first enter it and doesn't update to the current date/time?

I'm trying to create a date/time log of certain events that displays the
date and time in hh:mm:ss - I only need to be accurate within a few seconds,
but the point is that =NOW() wouldn't work.

Any suggestions would be appreciated.