Sum Hours
So I'm trying to add up all hours for each job, then be able to call up any job via drop down and have to automatically add up the hours for said job. Attached is an example of the sheet, where it says "AUGUST22" on the right that's where the dropdown is, I would also like the drop down to be alphabetized and have no repeats in it.
Last edited by Luigi802; 08-02-2022 at 03:20 PM. Reason: Forgot attachment
i think the links are broken - so nothing on the dropdown, not sure what jobs you want sum()
maybe provide some examples
that should simply be a SUMIF() or SUMIFS() from what you have saidthen be able to call up any job via drop down and have to automatically add up the hours for said job.
I cannot see this , maybe because of linksI would also like the drop down to be alphabetized and have no repeats in it.
you maybe able to sort() ,filter() , unique to get the dropdown asbut without a full sample sheet i cannot help here - sorryalphabetized and have no repeats in it
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Here are the instructions, found at the top of the page again
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Add a "TOTAL HOURS" column in your data table, then do a PivotTable with "WORK ORDER ID" in Filters area and "TOTAL HOURS" in Values area.
Thank you, good call on the pivot table, I did something like that already but not with a pivot. I was hoping to not have to add another column. I guess I could just hide the extra column, is there a way to get rid of it completely though?
Last edited by Luigi802; 08-03-2022 at 07:16 AM.
Try this:
=SUMPRODUCT((Table9[WORK ORDER ID]=G3)*((Table9[TIME
FINISH])-Table9[TIME
START]))
Custom format the cell as [hh]:mm.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Oh wow, awesome, that's exactly what I'm looking for! Thank you!
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Please make your thread titles more detailed in future.
Yes, create the "TOTAL HOURS" as a calculated field.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks