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.
|