Here's a good representation:

Date & Time In Date & Time Out
1 3/1/04 5:40 3/1/04 7:40
2 3/1/04 7:15 3/1/04 8:05
3 3/1/04 9:15 3/1/04 10:20
4 3/1/04 11:09 3/1/04 13:50
5 3/1/04 13:25 3/1/04 15:15
6 3/1/04 13:50 3/1/04 17:01
7 3/1/04 15:20 3/1/04 17:55
8 3/1/04 15:45 3/1/04 18:08
9 3/1/04 16:30 3/1/04 17:45
10 3/1/04 16:51 3/1/04 19:00
11 3/1/04 17:32 3/1/04 19:10
12 3/1/04 17:37 3/1/04 19:30
13 3/1/04 18:00 3/1/04 19:05
14 3/1/04 18:10 3/1/04 22:00
15 3/1/04 18:55 3/1/04 20:00
16 3/1/04 20:30 3/1/04 20:50
17 3/1/04 21:55 3/1/04 23:00
18 3/1/04 22:20 3/1/04 22:55
19 3/1/04 22:45 3/2/04 0:15
20 3/1/04 22:47 3/1/04 23:25

You'll see above, that row two starts before row one ends. The same thing
happens with rows 9 through 13 all starting before row 8 ends. Maybe that
will make a little more sense.

Thanx again.
"Pete_UK" wrote:

Steven,

I don't know what you mean by "five rows in a row". I assumed that your
posted example data was representative, and you did say that the data
was in sequence.

The formula I gave you will show any dead time between two adjacent
rows, so it will need to be copied down all the rows you have. The
total dead time is then obtained by summing all of these. Do you just
want a single-cell formula to do this?

If the dates are in Excel date format, then they can be added to the
time cells, such as:

=IF(A3+B3C2+D2,A3+B3-C2-D2,0) in E3, copied down.

I'm not sure if this is what you want, but post back if not.

Pete