• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

Calculate the service time

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
amq10
Asked:
amq10
  • 2
1 Solution
 
barry houdiniCommented:
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
 
amq10Author Commented:
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
 
barry houdiniCommented:
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
 
TommySzalapskiCommented:
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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now