Hi
I have a worksheet with column C (start time) & column D (end time).
(C1:D50)
e.g
C D
07:45 08:50
11:50 12:50
In Cells A1 and B1 i have the start break time and end break time
'08:00' and '08:20' for the first break.
In Cells A2 and B2 i have the start break time and end break time
'12:00' and '12:30' for the first break.

What i want to do is calculate the amount of time lost but exclude
both break times


can anyone help?