Hello,
I'm looking for a function to calculate the average time for a RTC to travel from loading back to loading:
In the sheet i have a list of RTC's (column B) and in column A the date it was loaded.
In the column B the RTC number will be repeating, as one RTC will be reloaded on the terminal.
I created a small scheme underneath the text, what has to explain what i need. I need to subtract the date A3 - A. Not sure if the scheme is understandable.
Also the data can be repeating more than once.
A list wit data is attached. Also one example of a duplicate value is marked as red. Please note that the loading dates are different.
RTC no. 54670161:
A(loaded 6.05.2012 23:30:00)------>B
B1----->A2
A3(loaded 24.05 02:00)----->B3
Bookmarks