You could use the time filters to get the time where the value was in deviation. Youtube video on using the PITimeFilter formula. Once you have this dataset you could use a Pivot table to filter the results set to only show the value of interest. There is a problem with this scheme; if you have a tag that goes in and out of deviation then the total "true" time will be returned.
Another (better) approach would be to use EventFrames. Create an EF whenever the attribute (it will be an AF Element and attribute now) exceeds the limits. In Excel you can simple return the EventFrames with a duration greater than the desired threshold. This will have the benefit of avoid the problem above, will have far better performance and your logic is only in one place. With AF 2.6 (Asset Based Analytics) and Datalink 5.1 this would be pretty easy to do.
Thanks for quick reply.
I will try to execute the first option & it will be great if you elaborate the second option more. I'm new to all this so i may ask some basic questions.