Formula Needed - Hours between times crossing midnight

Hi,

New to this forum and in need of some help!

At my workplace, people whos working hours fall between 10pm and 6am attract a higher rate of pay. I'd like a formula to work out how many hours fall within this timeframe based on the people's shifts. I've seen similar requests on the forum but can't get the solutions to work for me, maybe because the dates and times are in the same cell.

I've attached an example of how the data gets taken out of our Workforce Optimisation system. I need to know how many hours fall between. I@m using Excel 2013.

Many thanks!

Adam

Thanks for the responses.
Special-K, I found your formula worked fine where the finish time is the next day. I've attached a bit more data, showing that sometimes people don't work at all between those times, and as such they would not have any premium hours, in which case your formula doesn't work and gave the result as 07:15. Could you please let me know how to make it show that in such instances the number of hours is zero?

mehmetcik, I'm afraid I couldn't get your forumla to work as it produced the result of 2 in all instances.

Thank you

Adam

Just wondering if you managed to get chance to re-look at this?

Many thanks

Assuming people's shifts don't go to a huge number of hours (in excess of 16) perhaps the following

=IF(INT(D2)-INT(C2)>0,1-MAX(MOD(C2,1),22/24)+MIN(MOD(D2,1),6/24),IF(MOD(D2,1)>22/24,MOD(D2,1)-MAX(MOD(C2,1),22/24),0)+IF(MOD(C2,1)<6/24,MIN(MOD(D2,1),6/24)-MOD(C2,1),0))

Just seen your location. Its a small world!

davsth - This works just how I need it! Thank you so much.