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?

5/8/2019

2ND

4-1

Crane

OH Crane

Electrical

Motor

Bypass

17:30

3:00

-870

80

-950

Disconnect horn

-950

<tbody>
</tbody>

 

[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