Thread: now function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default now function
Or even... =NOW()-TODAY()

Or even

=MOD(NOW(),1)

--
Regards

Roger Govier


"Rick Rothstein (MVP - VB)" wrote in
message ...
NOW gives both the date and the time. in A1:

=NOW()-INT(NOW())

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

Rick


Reply With QuoteReply With Quote