0
Ångra
Röster
Hej alla,
I will attach an excel file with a macro that I found but it doesn't work 100%.
In columns C and D I have the time data and a value of a parameter.
It might seem that the hours and minutes for the data is always the same, so it only changes the number of the day/month, but it is not true. At 04/07/2016 the hour is 04:00:00 and all the data that is not 04:30:00 when I run the macro it transforms the 04:00:00 to 04:30:00 and the value of the parameter from 04:00:00 is changed to blank.
What I want is to fill the missing data to have the data by a step of 1 min
So 01/01/2016 00:00:00, then 01/01/2016 00:01:00, then 01/01/2016 00:02:00.
Hope I was clear about my doubt.
If in Matlab this would be easier I can also work in Matlab.
Tack för din tid
--
Med vänliga hälsningar,
James
I will attach an excel file with a macro that I found but it doesn't work 100%.
In columns C and D I have the time data and a value of a parameter.
It might seem that the hours and minutes for the data is always the same, so it only changes the number of the day/month, but it is not true. At 04/07/2016 the hour is 04:00:00 and all the data that is not 04:30:00 when I run the macro it transforms the 04:00:00 to 04:30:00 and the value of the parameter from 04:00:00 is changed to blank.
What I want is to fill the missing data to have the data by a step of 1 min
So 01/01/2016 00:00:00, then 01/01/2016 00:01:00, then 01/01/2016 00:02:00.
Hope I was clear about my doubt.
If in Matlab this would be easier I can also work in Matlab.
Tack för din tid
--
Med vänliga hälsningar,
James
Det finns inga svar på det här inlägget än.