View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jounardo jounardo is offline
external usenet poster
 
Posts: 2
Default How to put "between values" (e.g. 3-9) to the formula?

I want Excel to calculate how many hours there is between two times, but only
if there is more than 8 hours AND less than 10 hours between those two
values. How do I build up the formula? Or how to I put two different formulas
to the same cell?