Looking for help with VLookup (I think)

[katashatzu]

Hello, Im working on a project to record how long Ive been working on jobs in different applications. I have my main table which has the job number, start and end date and time, how many minutes and hours worked on each job, and which application I was using. Ive got a second table (this is where I need help) where I would like to total the time spent working in each application. If you look at the image Ive attached, I need the values in L4, L5, L6 etc.

This is there Im thinking I need a lookup (not my strong suit in excel)

For cell L4, I need to lookup the values in I6, I7, I8 etc, and see if theres an A there. If there is, the application used was access and Ill need to total the time up (value from the Hours column, so H6, H7 etc) and put that totaled value in cell L4.

Does that make sense? I dont really know how else to describe it. Hopefully someone can see what Im looking for. I appreciate any input!

Thanks in advance! -Dennis

ExcelHelp.jpg