•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What formula is best for a sum of time tracked with drop down categories of where time is spent?
Our take
Managing your time effectively can be a transformative step toward increased productivity. If you're using a table to track your time across various categories, calculating the total time spent in each category is essential. The right formula can help you achieve this, allowing you to visualize where your time goes and identify areas for improvement. In this guide, we’ll explore effective ways to sum time tracked with dropdown categories, ensuring you have the clarity and insights needed to optimize your time management strategy.
I am wanting to do a two week time management tracking for personal use in order to manage my time better. The table to the right is the table I am using in my data validation drop down under Categories.
What I want it to show me is a sum of time tracked for each category but I can't seem to figure it out. The formula I have in the current Time Tracked Table to the right is shown in the formula bar.
I think I am close to getting it to do what I want it to do, but can't find that missing step.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Time In Lieu SpreadsheetHey All, I have used Google Sheets forever but my new job uses Office and I am struggling with some of Excel's functions. I'm trying to create a spreadsheet that tracks my time off in lieu (TOIL) so I know where I'm at. I've created the bare bones of the spreadsheet ash shown in the image but I need help cleaning it up. Ideally I would like to have all of the time columns (B:H) only have hh:mm format and then all of the 0:00:00 values that haven't been used not to be shown. In cell L1 I would like it to show the most current level of TOIL, again in hh:mm format. Is this possible or am I asking too much of Excel? Thanks in advance. https://preview.redd.it/c8u5ha2cxszg1.png?width=1001&format=png&auto=webp&s=3985daa3d11541abed488f377c62e375f6ab1224 submitted by /u/Silky_45 [link] [comments]
- Countif or sumif when adding from a selection of a drop down and the range is in a different columnHi Reddit, I have a column for drop-down selection for machines and another one for time keeping. I'm trying to map out how long each machine is down for and use a pivot chart to make it visual. Any combinations of formulas I come up with come up broken. Any advice is appreciated - even chart visual. TYIA submitted by /u/HellsLamia [link] [comments]
- Proper maintenance of game activity tableI'm part of a team of a rather small hobby game that we've been running for many years now. We've been running simple activity summaries in hours spent like this monthly, ever since beginning in April 2017. They simply go like this: GM Matt - 65.7h M Aiden - 54.3h K Hawk - 32.1h K Tell - 30.0h M Poe - 27.6h T Tribux - 25.4h M Vair - 24.5h K Rodian - 23.3h K Eventide - 20.1h T Crab - 14.4h M Voss- 14.3h M Teir - 9.1h M Vallin - 4.4h T Forrte - 0.5h They're posted monthly so there are similar tables for May 2017, June 2017 and so forth up to April 2026. I want to start storing them all in Excel, this is what I did so far: https://preview.redd.it/n9oem7xh2zug1.png?width=1529&format=png&auto=webp&s=95855988839af802d4d6830df3996943eecdc85f The sum part for each year is simply: =SUM(D3:L3) and so on. Then there's a final column "ALLTIME" where I sum everything to the left except the columns with yearly sums. This works so far, but I'm wondering if there's a better approach that's gonna be more comfortable in the future if I want to extract more data. I have zero experience with data management and Excel, this is what came intuitively to me, but I want to know if there isn't something that will bite me in the ass in the future. submitted by /u/Informal-Ordinary387 [link] [comments]
- Index Match or Xlookup to return sum of row values based on matching two horizontal lookups?Ask: If E59:S59=E111 AND E60:s:60<-E112, give me the sum of E61:71,else return 0 What is the smoothest formula for this? I added in what I'm trying to do on the formula line. ChatGPT is less helpful with this than I am. I want to bundle by phase because our timesheet system doesn't allow me to pull a report by phase/task, only by person. I tried Xlookup but kept getting SPILL errors so I am at a loss. FTE1 is a different category and should not be included (PM, I can plug that as it's always in the same position). Thanks in advance for your help. https://preview.redd.it/yp4yzfn2rcxg1.png?width=2560&format=png&auto=webp&s=86eed1d2c8f3bb97c6d49592a0b1978d5f80f365 submitted by /u/Regular_or_BQ [link] [comments]