G
Guest
Anyone know how to modify this formula so it does not round anymore?
=IF(D22=TRUE, CEILING(MOD(NOW(),1),TIME(,5,)),"")
=IF(D22=TRUE, CEILING(MOD(NOW(),1),TIME(,5,)),"")
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=IF(D22,NOW(),"")
=IF(D22,NOW(),"")
P
Pete_UK
Try this:
=IF(D22=TRUE,NOW(),"")
However, NOW will return the system time and will continue to change,
so I'm not really sure what the purpose of the formula is.
Hope this helps.
Pete
=IF(D22=TRUE,NOW(),"")
However, NOW will return the system time and will continue to change,
so I'm not really sure what the purpose of the formula is.
Hope this helps.
Pete
G
Guest
Never mind....i figured it out...
=IF(D22=TRUE, MOD(NOW(),1),"")
Thanks anyway...
=IF(D22=TRUE, MOD(NOW(),1),"")
Thanks anyway...
P
Pete_UK
Try this:
=IF(D22=TRUE,MOD(NOW(),1),"")
However, NOW will return the system time and will continue to change,
so I'm not really sure what the purpose of the formula is.
Hope this helps.
Pete
=IF(D22=TRUE,MOD(NOW(),1),"")
However, NOW will return the system time and will continue to change,
so I'm not really sure what the purpose of the formula is.
Hope this helps.
Pete