Thread: time now
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default time now

"Pete_UK" wrote in message
oups.com...


Alternatively, if you have the NOW() formula in A1, then in B1

=A1 - INT(A1)

Why not =MOD(A1,1) <G


Reply With QuoteReply With Quote