Thread: Need help...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steven Sinclair
 
Posts: n/a
Default Need help...

Here's what I have...

Date_In Time_In Date_Out Time_Out
3/1 5:40 3/1 7:40
3/1 7:15 3/1 8:05
3/1 9:15 3/1 10:20
3/1 10:50 3/1 11:01
3/1 11:09 3/1 13:50
3/1 13:25 3/1 15:15

And so on, and so fourth.

What I need to accomplish is to calculate for any "dead" time between the
OUTs and the INs. On some rows, it is as simple as [=sum(d4-b5)], but I could
have many, many rows in sequence that may overlap the previous ones. This
seems so complicated to me...hope I'm explaining it correctly.

Any ideas?

Thanx.