• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculation / Formulas required - Daily Performance Report [ Actual Hold ]

MaunishP

Member
Hi Team, Please find attached workbook which has sheet 1 with raw data of a few employees worked on a day. Sheet 2 has data which I want to have it on daily basis. I had done few pivots and was not able to get below given pointers.


1) Actual Hold in entire day for 1 person. Now here is the concern for actual hold>


Lets take eg from the attached sheet> Employee Psharma started processing order [ 325123314 ] @ 8:20:55 AM she placed that order on hold " we don't have the time when did she placed on hold, only we have the total hold timings " then she started processing another order [ 325104259 ] @ 8:25:53 AM and uploaded it successfully @ 9:05:43 AM, " here also she kept on hold ", then she fetched previous order [325123314 ] from hold and uploaded it successfully @ 9:06:26 AM and so on she processed further orders .


Now here it want to know that what was the actual hold timings for the entire day. Sheet 3 has formulas which I have created however they are not coming accurate as you can see in sheet 4 pivot table. Please help me out with accurate formulas.


Can anyone the masters of excel help me out here to get accurate hold time [ actual ]. Please more details of data required please contact me on email refer my profile


Edit: By Hui - Email Address removed
 
Good day maunishp


The forum members are good, very good at helping but I think even they will have some trouble in opening your none posted workbook :)
 
Back
Top