Determine Duration between Start Time and End Time Taking into consideration shift hours

Hello Experts!

I have a start time and end time and I want to compute for the duration only within our shift hours.

Shift Start: 08:00 PM
Shift End: 5:00 AM (the next day)

Example 01

Start Time: 07/13/2015 03:30 AM
End Time: 07/14/2015 09:25 PM

With the above example the duration should be computed 1st from 07/13/2015 03:30 AM to 07/13/2015 05:00 AM which is 1:30 hours and 2nd from 07/14/2015 08:00 PM to 07/14/2015 09:25 PM which is 1:25 and if we total the 1:30 and 1:25 we will have 2:55 as the duration.

Example 02

Start Time: 07/13/2015 08:30 PM
End Time: 07/14/2015 01:00 AM

Since the above example is within the shift the duration is 4:30.

Thank you
Hudas

Can you post a mock up sample file please, remove sensitive Data 1st

Shift Start Date 8:00:00 PM
Shift End Date 5:00:00 AM (the next day)

Start Time End Time Duration
07/15/2015 1:14:34 AM 07/16/2015 9:44:34 PM
07/15/2015 1:51:37 AM 07/15/2015 4:58:37 AM
07/15/2015 8:00:34 PM 07/15/2015 11:01:39 PM

The Time duration from 5:00:01 AM to 7:59:59 PM should not be included in the computation. I've tried to attached a file but i'm having some network issues.

Thank you
Hudas