cyiangou- thank you very much, this approach will work quite well.

newdoverman- thank you, i think i see where you were going with this and will try it with more data. p.s. if you were wondering why some of my seconds calculations were doubled, it's because some "statuses" apply twice. I removed the multiplier column from the sample data without realizing this would make it confusing.