IF function with Time difference

*Time is in 24 hour clock*

Monday 06:00 to 19:00 (Would be 1 hour in total)
Tuesday 05:30 to 16:00 (Would be half an hour in total)
Wednesday 05:30 to 18:30 (Would be 1 hour in total)

I would like a function that can count certain hours between the the given shifts.

So an "IF function" that counts the hours >(less than) 6:00 but also >(greater than) 18:00, so you get the total amount of hours Both less than 6AM and greater than 6PM.

I have created an IF function that can count the hours past 6pm, and also one that can count before 6am, but I have failed to create one that can do both and add them together.

why would this be half an hour?
Tuesday 05:30 to 16:00 (Would be half an hour in total)

Try in D2 and down:
=(VALUE(C2)-VALUE(B2))-0.5

Try this

Formula:

Please Login or Register  to view this content.