How to calculate the time difference between the same column depending on the another column.

[Anonymous]

Here have the table of data, need to calculate the time difference of column "Time" according to between "Category" between B and A. Its like A-B -> 10:05 - 10.00 = 00.05.

Some times the Category values could be repeated on the some seconds value. still we need to calculate the time between A and B.

Thanks in Advance.

[amustafa]

Hi @Anonymous calculating the time difference is the easy part. You need to define all different scenerios in your data first and provide a sample data in text format so it can be copied. 
Does the category values always A and B? If yes you can transform the data to a single line TIME A, TIME B then calculate the time difference.
What about the VALUE column, doe sit need to be considered in any calculation?
If Category repeats with som eseconds do should you take the latest or earliest value?