Seprate the queuing time from the process time

Hi,

I have data for a process in such system which has is like that
Arrival time       end of process time                        

I have calculate the inter-arrival time between arrives and time between process and arrival which represents the waiting and process time. My question is how to know the process time and waiting time for each task.

Example for ten tasks:
   
inter-arrival time in hours     waiting                    process               time between arrivals and end of process
0                                                   0                             2.18 (as first one)           2.18
0.73                                               ?                              ?                                    1.50
0.03                                               ?                              ?                                     9.04
0.72                                               ?                              ?                                     3.79
0.13                                                                                                                     9.31
0.17                                                                                                                    1.94
0.53                                                                                                                    0.94
0.74                                                                                                                    4.32
2.93                                                                                                                    3.93
1.47                                                                                                                    4.45


how to calculate proceed and waiting time for each task ?
amq10Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnb25Commented:
Hi,

If I understand what you are asking, it is easier done with the Arrival time and End of Process time.
Can you post the original data?

John
0
amq10Author Commented:
Hi John,
Thanks for your comment. The deference between end of process and arrival will gives the process time and waiting time together. I need to know long the task takes in the process and in the waiting queue.

Please find the attached, which  is a sample of the original data. Please note that the difference there are holidays and weekends between arrival and process have been removed in the processed times in the last two columns .

Thanks
Abdul
0
johnb25Commented:
Abdul,

Are these processes sequential?
I have assumed yet, and done some calculations, but it is not making sense.

I don't see any attachment on your previous post.

John
EE-Times.xlsb
0
amq10Author Commented:
Thanks John for your reply. Actually, your calculation has a problem. That will be clear if you add the waiting time with  process time for each task will give different number,as you put the process time like the total. Andy way. I have sort it out. by doning this calculation

= (waiting time for second task - inter arrival of the second task)+ (total time of task1-waiting time of task1)

Thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
amq10Author Commented:
I have add the solution as I found it and selected it as the best solution. Although, the expert solution it doesn't work, I gave his the point as I respect his effort with me.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Math / Science

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.