total time spent for a specific employee

Hello there, I'm a self-taught Excel user and learning as I go... so you help is certainly appreciated.

I've created a worksheet to log employee information when at job sites (i.e. time log) on this sheet we track their name, time in, time out, total time, location, etc... I am wanting to create a formula so I can get the total time spent for a specific employee.

The time columns are formated cells whereas the name is not. I have been trying to play around and figure it out however I am just getting too frustrated (hehe).... when I use a SUM formula, because the cells are formated, it is not accurate... PLEASE HELP!!!

Hi

I have attached an example which I think fits, if it does not please let me know.

Regards

Jeff