Total Minutes Not Crossing Next Day

[reyrey]

Looking to see if there's a function that would capture the total number of overtime minutes in a day but not counting the minutes crossing the following day.

[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD]Start Day
[/TD]
[TD]End Day
[/TD]
[TD]Start Overtime
[/TD]
[TD]End Overtime
[/TD]
[TD]Total (min)
[/TD]
[/TR]
[TR]
[TD]10/05/2017 0:00
[/TD]
[TD]10/05/2017 23:59
[/TD]
[TD]10/05/2017 08:00
[/TD]
[TD]10/05/2017 10:00
[/TD]
[TD]120
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]10/04/2017 23:00
[/TD]
[TD]10/05/2017 01:00
[/TD]
[TD]120
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]10/05/2017 23:30
[/TD]
[TD]10/06/2017 05:00
[/TD]
[TD]330
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Does this formula give you what you want...

=1440*(MAX(D2,INT(D2))-C2)

 

[reyrey]

It doesn't really give me exactly what I'm looking for. End result does not change if i change the Start Day and End Day