Data shows up as 1 or 0 in pivot table

[Chookz]

Hi all,
I am trying to construct a pivot table from an excel database ive made. Ive added my fields the way i want it setup and by default my data is summarised by count. This shows up as 1 in the data field. When I try and change the 'summarise data by' to sum it comes up as 0, and when i try to summarise by average i get #DIV/0! and i dont know how to get my data (most of which i formatted h:mm:ss) to show up. Am I doing something wrong with my pivot table or is anyone able to help me get my data to show up? Im very new with pivot tables and have been thrown in the deep end at work, so any help is greatly appreciated.
Ill add a link to a screen shot of my pivot table if that helps.

Cheers

http://i53.tinypic.com/16banpv.jpg

 

[RoryA]

Assuming data in A1:
=--LEFT(A1,SEARCH(" ",A1)-1)
and
=--(SUBSTITUTE(MID(A1,SEARCH(" ",A1)+2,LEN(A1)),")",""))

 

[Chookz]

Thanks rorya, you've been a fantastic and fast help! Really appreciated

 

[RoryA]

Glad to help.