Re: Pivot, Summarize values by Maximum, 24-hour clock
Would be hard to do. Code runs by starting at bottom and going backwards towards top. So, it doesn't know before hand how many instances there will be. It'd be easier to build a concatenating formula afterwards, like:
=IF(C2="Down Time","Down Time " & COUNTIFS(A$2:a2,a2,B$2:b2,B2),C2)
And then that should give you something close to what you want.