Time calculation for specific activity based against date criteria

[dacourt]

=IF(ISNUMBER(G2),IF(G2<>G3,SUMIF($G:$G,G2,$J:$J),""))



I am looking for some advice for a formula to be able to calculate a total for the period of time that exceeds 9 mins in a running column. The data entered is based against a date criteria range in another column.

The formula above is what I am using to calculate the total activity but I just need to separate out any periods that =>9 mins as a separate entry.

In the above G is the date with J as the individual job cycle time. Ideally, every job should be under 9mins, so I need to break out and total any job that exceeds 9mins. Like I said I cannot seem to be able to post an example.

Any advice gratefully accepted.

[protonLeah]

Please Login or Register  to view this content.

=if(f2-"00:09:00"<0,0,f2-"00:09:00")

[dacourt]

Thanks Ben

Will this give me the daily sum total for those amount episodes that meet or exceed the 9 min target. That is what I need. I will generally have 20 to 30 rows of data per day and possible 1/3 to 1/2 will have episodes over 9 mins and I need to calculate that total time.

Regards
David

[FlameRetired]

Perhaps this in H2 and filled down.

Please Login or Register  to view this content.