Formula Needed - Hours between times crossing midnight

[meowmix7903]

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