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
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