Hi,

Dies this work, it must have the later time in B1

=IF(AND((B1-A1)*24=8,(B1-A1)*24<=10),(B1-A1)*24,"Unspecified")

Because you don't say what you want for <8 10 the formula returns
unspecified.

Mike

"jounardo" wrote:

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?