V
Vebjørn
Hello
I work on a time series in Excel that should be used in the EPA SWMM. (Storm
water modelling)
Eks of the series:
Date (D/M/Y) Time(H:M) Value (mm)
06/05/2002 00:35 0.2
06/05/2002 02:43 0.2
06/05/2002 03:26 0.2
06/05/2002 03:39 0.2
06/05/2002 04:03 0.2
06/05/2002 04:12 0.2
06/10/2002 01:07 0.2
I need to have values for every minute. Sow i need to insert a row between
the eksisting times. Eks from 00:35 to 02:45 i need 129 rows whit the same
date, one more minute added and the value 0
Eks:
06/05/2002 00:36 0.0
06/10/2002 00:37 0.0
Hope for some answers!!!!
I work on a time series in Excel that should be used in the EPA SWMM. (Storm
water modelling)
Eks of the series:
Date (D/M/Y) Time(H:M) Value (mm)
06/05/2002 00:35 0.2
06/05/2002 02:43 0.2
06/05/2002 03:26 0.2
06/05/2002 03:39 0.2
06/05/2002 04:03 0.2
06/05/2002 04:12 0.2
06/10/2002 01:07 0.2
I need to have values for every minute. Sow i need to insert a row between
the eksisting times. Eks from 00:35 to 02:45 i need 129 rows whit the same
date, one more minute added and the value 0
Eks:
06/05/2002 00:36 0.0
06/10/2002 00:37 0.0
Hope for some answers!!!!