There are two ways to solve it, with a macro and without. In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.
With a formula, you can tell excel to put true if it is the case and correct it manually.
For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail [email protected]
Answers & Comments
There are two ways to solve it, with a macro and without.
In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.
With a formula, you can tell excel to put true if it is the case and correct it manually.
For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail [email protected]