I am not sure what your data look like, but if it is consistent, then can you use =AVERAGE(B1,B11,B21) where B1, B11 and B21 would be the last 3 days' 8:30 entries? Or is it more complicated? And if so, please post sample dataset and expected results.