Hi guys, I need a help with this time series and list of figure.
I have a column of dates and hours. To each of them corresponds a figure.
<tbody>
</tbody>
Dates and hours are organized from the oldest to the most recent, but sometimes hours / dates are missing. I need to fill column B with zeros for those hours where the figure is missing.
<tbody>
</tbody>
thanks a lot!
Best
Amanda
I have a column of dates and hours. To each of them corresponds a figure.
column A | column B |
01/01/2011 00:00 | 40 |
01/01/2011 01:00 | -98 |
01/01/2011 06:00 | 55 |
01/01/2011 18:00 | 45 |
<tbody>
</tbody>
Dates and hours are organized from the oldest to the most recent, but sometimes hours / dates are missing. I need to fill column B with zeros for those hours where the figure is missing.
column A | column B |
01/01/2011 00:00 | 40 |
01/01/2011 01:00 | -98 |
01/01/2011 02:00 | 0 |
01/01/2011 03:00 | 0 |
01/01/2011 04:00 | 0 |
01/01/2011 05:00 | 0 |
01/01/2011 06:00 | 55 |
..... | 0 |
.... |
<tbody>
</tbody>
thanks a lot!
Best
Amanda