time calculations

[Chinngineer]

I have a database that we input repair times. I used the formula =SUM(FINISHTIME-STARTTIME)*1440. It registers the time difference in minutes. It has worked well until now we had a 9.5 hr downtime that ran from one day to the next. Instead of coming up with the 570 minute repair time, it comes up with negative 870. Can anyone help me with this?

[TABLE="width: 2196"]
<tbody>[TR]
[TD="class: xl76, width: 73"]5/8/2019[/TD]
[TD="class: xl65, width: 59"]2ND[/TD]
[TD="class: xl66, width: 65"]4-1[/TD]
[TD="class: xl63, width: 121"]Crane[/TD]
[TD="class: xl67, width: 86"]OH Crane[/TD]
[TD="class: xl68, width: 112"]Electrical[/TD]
[TD="class: xl69, width: 114"]Motor[/TD]
[TD="class: xl70, width: 110"]Bypass[/TD]
[TD="class: xl71, width: 104"]17:30[/TD]
[TD="class: xl71, width: 112"]3:00[/TD]
[TD="class: xl72, width: 115"]-870[/TD]
[TD="class: xl73, width: 98"]80[/TD]
[TD="class: xl74, width: 93"]-950[/TD]
[TD="class: xl75, width: 69"] [/TD]
[TD="class: xl64, width: 535"]Disconnect horn[/TD]
[TD="class: xl78, width: 74"]-950[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Finalfight40]

How about:

=IF( FINISHTIME < STARTTIME, (1+FINISHTIME -STARTTIME)*1440, (FINISHTIME -STARTTIME)*1440)<starttime, (1+finishtime-starttime)*1440,="" (finishtime-starttime)*1440)<="" html=""></starttime,>

 

[Chinngineer]

That worked! I had tried a similar formula but didn't work before. Thank you