Solved

Calculate the service time

Posted on 2014-03-08
4
135 Views
Last Modified: 2014-07-31
Hi,

I have a data which has a time for wating and service togather, I can't identify the service time. What I have done to calculate the service time for each task. I have calculate the time between the time of output from the service activity and assume that is the service time for each customer. e.g.,

task       time of output         service time
1              08:20                             ?
2              08:30                        0:10
3              09:00                        0:30
4              10:00                        1:00        


Is this process correct to calculate the service time? note the first one will be ignore due to I have no idea the previous one of the first task
0
Comment
Question by:amq10
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 39914675
That seems like a reasonable approach to me, will the times possibly run in to another day? If so you will need to use a formula that will cope with that too, e.g.

=MOD(B3-B2,1)

using MOD function will give you the correct output even when you go from, 23:00 to 02:00
......or do you need working hours only?

regards, barry
0
 

Author Comment

by:amq10
ID: 39915845
Thanks Barry,

for the time of another day or hours out of work. I have used a formula to calculate the working time only. But my question is that does the way above to calculate the service time correct?
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 39915896
Without knowing your exact definition of "Service Time" I can't answer that question for sure. You haven't even said which formula you are using, I assume =B3-B2

That will certainly give you the difference between each pair of times.

regards, barry
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 39917650
Do you know there is no idle time?

If task 4 did not arrive until 9:30, then the service provider would have been idle from 9:00 - 9:30 and the service time would be only 30 minutes.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

717 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