Hello Everyone,

I have a table with lots columns but two columns with the following example data,

Opened Time Closed Time
09/04/2010 16:50 12/04/2010 16:09
13/04/2010 15:37 13/04/2010 16:28
09/04/2010 14:55 12/04/2010 15:15
09/04/2010 14:55 12/04/2010 15:16
09/04/2010 14:55 12/04/2010 15:17
12/04/2010 15:45 12/04/2010 16:35
12/04/2010 16:32 12/04/2010 17:04
13/04/2010 15:39 13/04/2010 16:20

Check out this screenshot for more info.
\1

When I create a pivot table from this data and want to display it in another form I get empty entry where there is duplicate opened time, I run a formula on the data to generate the time between the two dates but due to pivot table grouping the rows when the open date is exactly the same I am getting errors.

Does anyone know how to stop pivot tables from grouping the rows when the data is the same?

Thanks