I am wanting to write a formula that calculates the span of time and highlights if an employee has worked more than 3 hours and if so, at least 5 hours
for example (C11-B11<=500,INPUT!B9,0) - but this does not include the formula regarding more than 3 hours
C11 = 12:30
B11 = 07:00
INPUT!B9 = 5:00
Any help would be awesome.