Need a formula to calculate performance percentages relating to time taken versus time expected standards
Our take
I am wanting to create what feels like a complex formula. Essentially, I have a table at work (which i cannot share for hopefully obvious reasons) that helps me convert time taken into a decimal hour. That's great and all, but I would also like to get a real time percentage comparing how long I took versus how long I should have taken.
I work different processes and each one has its own standard of time to complete. I also have to record how many of each process I do every day.
An example would be Process A requires one completion every 45 minutes, while Process B requires one completion every 3 hours, and Process C requires one completion every 5.5 hours. I want to compare my rate of completion in real time as the day progresses. Like, I completed one Process A in 55 minutes, so my rate is at 81.8% instead of 100%, or maybe I only took 35 minutes so my rate is 128.57%.
Anyone have a suggestion that will compare the desired rate from one column to my actual rate in another column, with specification of process names?
I consider myself intermediate at Excel, at best.
TIA!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What formula for timeplan milestone allocation?Hi All, I am trying to build a tool but there is one function I am unable to wrap my head around. I was hoping for some help from your end. Underneath you can find a simple reflection of what I am trying to do. We have a table with milestones in there. Next we have a timeline which I want to show the milestones in the month reflected to the dates in the table. (the bottom section shows what I want) obviously adding the percentages is an easy Vlookup based on the milestone names but how do I manage to get the milestone names in the right fields? Any suggestions are welcome - I am trying to not use VBA or macro's https://preview.redd.it/pu4vi8weetmg1.png?width=1730&format=png&auto=webp&s=2a1422a5dc91f0122aeace02eab392d9b2c9ae84 submitted by /u/EpilEpic [link] [comments]
- What formula is best for a sum of time tracked with drop down categories of where time is spent?https://preview.redd.it/mhqsrxla32qg1.png?width=1582&format=png&auto=webp&s=b582fe290370a96f50088ceac412215ebb8bd8a3 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. submitted by /u/Double-Ad9259 [link] [comments]
- Daily Average from Continuous Monthly TotalsWorking with employee productivity and they are required to perform to specific requirements. I am looking to bring our reporting into this century. I have monthly totals that update every month and I want a daily average to adjust as the months are added not by 12 months from day 1. I'm actually in need for a couple different formulas. Percentage of denied and approved refunds and the daily average. Remember all totals will go up every month when those are added. I tried the percentage formula but was not getting the right number and 2 zeros were added and could not remove them with the decrease decimal option. Any help or suggestions are welcome and appreciated. submitted by /u/Babe223377Jess [link] [comments]
- Solving for (constant/unknown=given value) where I give the desired output of a ratio and get the initial value needed.Excel Version Office 365 ver. 2603 build 19822.20182 click-to-run Excel Environment Windows desktop Your Knowledge Level Haven't touched excel in decades I have a formula where I input a value and it splits it in 3 ratios (0.1:50:50). D26 has the formula (=$A$1/100.1) to get the value of one part. B1-3 have the ratios 0.1, 50, and 50. C1-3 have the formulae (B1-3*$D$26) to get the shares of A1 by each ratio. I'm looking for a formula where I can input a desired share amount for any of the ratios and get the initial value needed to produce that share EDIT: I know I'm probably waayyyyyyy overthinking this, but its driving me crazy EDIT2: Example - An A1 value of 500 gives: a D26 of 4.995005, and C1-3 of 0.4995, 249.7502 and 249.7502. I want to, for example, input a C1 of 500 and get the A1 required to get that. Which, plugging-and-chugging my example, would be 500500 submitted by /u/LordSloth113 [link] [comments]