Need to Calculate ThruPut Time

  • Thread starter Thread starter Parker
  • Start date Start date
P

Parker

I need to add fields to an existing Access DB: Date and
Time the process started and the date and time the process
ended. I will need to determine what was the total thru
put time for this process. Question 1) is it best to have
4 different fields, or 2 (date/time combo)? Q2) what calc
do I used to get the thru put time. Keep in mind the
whole process could take weeks. Example Start 03/01/04
21:08:04 Stop 03/09/04 07:05:02. I need to know how
long did it take, in days, hours and minutes. Appreicate
any help you may give. Thanks.
 
I need to add fields to an existing Access DB: Date and
Time the process started and the date and time the process
ended. I will need to determine what was the total thru
put time for this process. Question 1) is it best to have
4 different fields, or 2 (date/time combo)?
Two.

Q2) what calc
do I used to get the thru put time. Keep in mind the
whole process could take weeks. Example Start 03/01/04
21:08:04 Stop 03/09/04 07:05:02. I need to know how
long did it take, in days, hours and minutes. Appreicate
any help you may give. Thanks.
Click to expand...

DateDiff("n", [Start], [Stop]) will give you a Long Integer count of
minutes; you can display this as days, hours and minutes using an
expression like

[Elapsed] \ 1440 & " days, " & Format([Elapsed] \ 60 MOD 24, "00hr ")
& Format([Elapsed] MOD 60, "00mn")
 
Back
Top