Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy Randy is offline
external usenet poster
  
Posts: 213
Default Formula Help
Anyone know how to modify this formula so it does not round anymore?

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

--
Randy Street
Rancho Cucamonga, CA
Reply With QuoteReply With Quote