Thread: Divide # by portion of the day??? compare to previous total column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
  
Posts: 383
Default Divide # by portion of the day??? compare to previous total co
sorry for so many replies, I'm working at it, is this the answer for that?

=((IF(NOW()<TIME(16,0,0),$DC$3,TIME(16,0,0))-TIME(9,30,0))/(TIME(16,0,0)-TIME(9,30,0)))*$M$4
Reply With QuoteReply With Quote