Try this instead of just NOW():

=MOD(NOW(),1)

Hope this helps.

Pete