I have the following scenario:
A text file with data, where one column is datetime and containing the date and time when the record has been entered.
I made a query (power query) in excel to read in the data, do some filtering etc and load the result to a table on a worksheet.
I want to have an extra column next to that table, where I calculate the change in time between the records (ie datetime record 2 minus datetime record 1... ). The formula speaks for itself, but my question is: how to let automatically expand and shrink
the height of the new column when the number of records changes and keep the calculation right?
KR
Wannes
