TIMESHEET - time calculation for multiple jobs type

Hi

Have a look at the attached timesheet.

I'VE ATTACHED WRONG FILE, SORRY GUYS. CORRECT FILE IN POST #4

I want to be able to calculate times I have spent doing different jobs types.
There are 5 job types MAINTENANCE, REPAIR, INSTALL, EXTRA WORK and OFFICE WORK and i would like automatically summarise time spent
on each TYPE of job at the bottom in cells D20, D21, D22, D23, D24
So I need to find a way for Excel to add all hours I have spent doing MAINTENANCE for example.

I think that the way to do that is to use a formula that would look for word MAINTENANCE in column J and then add all the hours from column I for the rows with word MAINTENANCE. After adding all those hours the summary would be displayed in cell D20. And then to do same for other types of jobs.

I just simply haven't got a clue how to do that.

I will be grateful for any help!

Hi smarczak

Welcome to the Forum!!!
Did you attach the correct File?

I see no reference to this in your File...

There are 5 job types MAINTENANCE, REPAIR, INSTALL, EXTRA WORK and OFFICE WORK and i would like automatically summarise time spent
on each TYPE of job at the bottom in cells D20, D21, D22, D23, D24

Or this...

I think that the way to do that is to use a formula that would look for word MAINTENANCE in column J and then add all the hours from column I for the rows with word MAINTENANCE. After adding all those hours the summary would be displayed in cell D20. And then to do same for other types of jobs.

is that what you want? (with PowerQuery add-in for Ex2013)

With formula.

Try this formula in D20 and fill down.

Formula:

Please Login or Register  to view this content.

Hi smarczak

Another Formula approach...

2017-11-17_11-54-14.jpg

Returns this...

2017-11-17_12-02-38.jpg

You're welcome...glad I could help. Thanks for the Rep.

again , thanks for help.

Please see attached the Timesheet file.
I will be using it on iphone with WPS Office hoping it will make my life and my workmates easier. I jutst hate paperwork

Sheet is protected and password is 1234

Everyone is welcome to use it and I would be glad if anyone can suggest any improvements or ideas.

I wanted to make it as easy as possible and prevent mistakes so a lot of drop down lists in the cells.