Thread: verify use of TIME Function, Find Quantity Level compare to time-d
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
  
Posts: 383
Default verify use of TIME Function, Find Quantity Level compare to ti
is this correct:

=((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