Try:

=SUM(E1:E2-D1:D2,-(E9:E11-D9:D11),--(E1:E2<D1:D2),--
(E9:E11<D9:D11))

Array-entered (press ctrl + shift + enter).

This gives you total run time for the 2 main runs (D1 to
E1 and D2 to E2) minus any machine downtime.

Format the formula cell as time.

HTH
Jason
Atlanta, GA

-----Original Message-----
I wish to calculate the time the machine has actually
run.

D1 = 22:00 (Start Time) F1= Time Run
E1 = 00:15 (Finish Time)

D2 = 00:15 (Start) F2= Time Run
E2 = 02:30 (Finish)

D9 = 22:20 (Breakdown)
E9 = 22:30 (Restart)
D10 = 23:15 (Breakdown)
E10 = 23:30 (Restart)
D11 = 00:30 (Breakdown)
E11 = 02:00 (Restart)

Is there a formula that can scan a range (D9:E11) and
give me tha answer in F1 of the time run between the
Start & Finish times

any help would be appreciated

Pete

.