Thread: verify use of TIME Function, Find Quantity Level compare to time-d
View Single Post
  #10   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
thanks for your help, the following reduction seems to work

=((MIN($DC$3,"16:00")-"9:30")/("16:00"-"9:30"))*$M$5
=((MIN($DC$3,TIME(16,0,0))-"9:30")/("16:00"-"9:30"))*$M$5
=((IF($DC$3<TIME(16,0,0),$DC$3,"16:00")-"9:30")/("16:00"-"9:30"))*$M$4

"Toppers" wrote:

.. better ?

=((MIN($DC$3,TIME(16,0,0))-"9:30")/("16:00"-"9:30"))*$M$4
Reply With QuoteReply With Quote