Need a formula to calculate performance percentages relating to time taken versus time expected standards
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]
Want to read more?
Check out the full article on the original site