Thread
:
time now
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
Posts: n/a
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
Reply With Quote