Hi Michelle

Next to your column where you calculate Time Taken, have another column
called 10_Mins_plus
Assuming this is column D and your Time Taken is column C enter
=(C2*24*60)10
and copy down

This will return TRUE for those rows where the time taken is greater
than 10 minutes.
Excel stores Time as fractions of a day, so multiplying by 24, gives
hours and then by 60 turns the result into minutes.

Incorporate the new column into your PT and select for True or False as
appropriate.

--
Regards

Roger Govier


"Michelle B" <Michelle wrote in message
...
I am using Excel 2003. I have a spreadsheet that has columns for"Time
Started", "Time Finished" & use these to calulate "Time Taken". In my
pivot
table I need to know how many activities took longer than 10 minutes
and how
many were either equal to or less than 10 minutes. The data in the
spreadsheet is imported from another system and changes daily. Have
been
battling with this for hours now @ would appreciate any ideas?