Thanks JE, as much as I've struggled with that it looks too simple but it
usually is. I'm sure this will do the job


"JE McGimpsey" wrote:

One way:

J2: =IF(I2="","",I2)
J3: =IF(I3="","",J2-I3)

Copy J3 down to J31


In article ,
miltdp wrote:

Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent.