Thread: now function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default now function
NOW gives both the date and the time. in A1:

=NOW()-INT(NOW())

Or even... =NOW()-TODAY()

Rick
Reply With QuoteReply With Quote