how to convert minute rainfall to daily rainfall with missing value?

Thank you for your prompt response.
Please find attached.

You have a column labeled Daily Rain, although the table has 144 rows for the same date. Do you want to repeat daily rain 144 times?

If so put this formula in F3 and copy down:

Formula:

Please Login or Register  to view this content.

I don't understand your point about missing values. In your sample data, there are no blanks, so I don't see anything missing. If you have other cases where it's actually missing, you can't just make up data. You could interpolate, but I don't think that would be very accurate for rain data taken at 10-minute intervals. If the data is not there, it's not there.

As you correctly mentioned the table has 144 rows for this date (140101) but for the other station for the same date the table has 142 rows. I would like to sum the accumulated rainfall in F based on the date changed (from 140101 to 140102, amount of rows are not always 144).

Maybe I don't understand what you want. Do you want total rainfall for each full day, or cumulative rainfall for the day at each 10-minute interval?

Originally Posted by 6StringJazzer

Maybe I don't understand what you want. Do you want total rainfall for each full day, or cumulative rainfall for the day at each 10-minute interval?

Dear 6StringJazzer,
I need the total rainfall for each full day.

Based on your layout that's what I provided. But it will repeat on every row. If you want a separate list of dates with rainfall, one row for each date, then you need a different layout.