Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |