One way:

=IF(D22,NOW(),"")

In article ,
Randy wrote:

Anyone know how to modify this formula so it does not round anymore?

=IF(D22=TRUE, CEILING(MOD(NOW(),1),TIME(,5,)),"")