Hello Community!



I have a big problem. I want to calculate the progress per day (2015-3-12 06:00 to 2015-3-13 06:00).

I tried this with vlookup(), that worked very well, but when at some dates arent any lengths (C80 : D96; C140 : D150), then it gives me the wrong progress.

Do you know a formular how to ignore the "0"?

The mistake in my example is from 14.3.2015 04:15 to 14.3.2015 08:00!

please can you help me?

Attached Files

example3.xlsx (31.6 KB, 9 views)

Trying to parse this out. There are a few questions regarding the data:

* Your first set of equations is looking for a start of 2015-03-12 06:00 and an end of 2015-03-13 06:00. For the start, there are two identical cells right at the top. For the end, there are also two cells though they are not consecutive (B68 and B51).

* The measurement intervals seem to vary widely, any where from 15 to 480 minutes. Is that right?

* Lastly, there seem to be quite a few duplicates.

At any rate, I guess the problem with the third is that the zero data are some kind of mistake or something like that, correct? So, in that case, you want it to use the previous data of 8.8. Is that right?

Thanks for your answer.

I already got an solution.

Regards, Patrick