Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Seprate the queuing time from the process time

Posted on 2014-08-19
Medium Priority
Last Modified: 2014-08-31

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 ?
Question by:amq10
  • 3
  • 2

Expert Comment

ID: 40270206

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?


Author Comment

ID: 40275898
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 .


Assisted Solution

johnb25 earned 1500 total points
ID: 40275965

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.


Accepted Solution

amq10 earned 0 total points
ID: 40285652
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)


Author Closing Comment

ID: 40295245
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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question