EXCEL

Hello, 

I have a report that I need to split down, there are list of names and times taken to do certain jobs.

I want to be able to import the report and it automatically breakdown on a seperate sheet to how much time has been taken for each person and the hours charged for it. 

what formula do I need to be able to do this and is it something that is acheiveable, I don't really want a pivot table if it can be helped. 

Any help would be great! 

thanks 

Katie  :)