S seansr Member Apr 6, 2020 #1 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 Attachments rows and columns.xlsx 17.5 KB · Views: 5
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
N Naresh Yadav Active Member Apr 6, 2020 #2 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 Attachments rows and columns.xlsx 18.2 KB · Views: 8
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
