add up total per user per type

[seansr]

I have a spreadsheet that is produced every month and I need to add up the total time per team member per type

so I can show total hours spend on chargeable and foc work

Example spreadsheet attached

Many Thanks

Sean

 

[Naresh Yadav]

Try this one...

=SUMIFS($L$2:$L$15,$A$2:$A$15,B$27,$M$2:$M$15,$A28) and change the format to [h]:mm:ss by going to custom format thru CTRL+1
your excel sheet is attached for your reference

regards
Naresh

 

[seansr]

Thank you very much