Hi Elizabeth, okay, these two should give you your incident numbers as you want them, as well as a running total of hours in each incident, and have the bonus of being easier to understand:
In D2:
In E2:
Copied downward.
Does that help?
---------- Post added at 08:15 AM ---------- Previous post was at 07:58 AM ----------
As an aside, this might be useful in your "Help1" column:
=TEXT($B2,"dddd")
and this is how I would normally have used the first formula in post #10:
=IF(ROW()=ROW($2:$2),1,$D1+($A2<>$A1)+($A2=$A1)*(NETWORKDAYS($B1,$B2)>2))
---------- Post added at 08:18 AM ---------- Previous post was at 08:15 AM ----------
As an aside, this might be useful in your "Help1" column:
=TEXT($B2,"dddd")
and this is how I would normally have used the first formula in post #10:
=IF(ROW()=ROW($2:$2),1,$D1+($A2<>$A1)+($A2=$A1)*(NETWORKDAYS($B1,$B2)>2))
Bookmarks