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

Instead of using NOW() in a cell, replace it with MOD(NOW(),1)

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

=A1 - INT(A1)

Format as time.

Hope this helps.

Pete