You can define filters on data columns for SQL Server Profiler trace events so that only those events information are captured that you need.
You add filters to trace definitions by using the Events Selection tab of the Trace Properties dialog.
Click on the Column Filters button, and you will see Edit Filter.
The Edit Filter dialog contains a list of comparison operators that you can use to filter events in a trace.
To apply a filter, click the Duration column heading, expand Greater than or Less than, and then enter a
100000 value in the field that appears beneath the comparison operator.
You can also check the Exclude rows that do not contain values checkbox and then click the OK button.
Now you will see only those rows which have Duration greater than 100000 ms.