Calculating using the 24hr clock

[mattie17uk]

I hve a wk/sheet which logs what jobs a machine does when and how long the jobs took.
The times for these jobs are in 24hr format.

My problem is when a time goes from one day to the next (machine runs 24hrs a day)
e.g Job start 23:55 job finish 01:55 on the next day.
Whats the best formula to use to get the difference between the two times in minutes.

Thanks in advance for any help.

 

[Aladin Akyurek]

=B1+(B1<A1)-A1

 

[mattie17uk]

Thanks Aladin
Once again Mr Excel.com comes to the rescue.

Thanks again