Greetings
I have created an application for use in a production facility, for logging job and task progress, along with elapsed times. Operators "start" tasks, and "end" tasks with a click of a command button, or a swipe of a barcode scanner. The "start" or "end" action runs an append query that populates separate tables, using the time() function.
I then have a listbox, with a query for the source. The query uses both the start and end tables. In the query, I use:
Elapsed: Format([Start]-1-[End],"hh:nn:ss"
This displays the "elapsed time" correctly, if I was only concerned with displaying individual elapsed times.
However, I am actually trying to create an actual database of times that can be manipulated, and reported on. Totals, division for averages, etc. From what I can understand, searching through all the threads, Access is not really storing minutes and seconds, but reference points in a 24 hour cycle, even though you can format the results to "look like" elapsed times.
So I am assuming I am going to have to use VBA to achieve this goal. Specifically, I want to be able to take my "elapsed time" and divide it by whole numbers. For instance:
01:15:10 divided by # of doors equals X minutes and X seconds per door. (hh:nn:ss)
Or;
01:15:10 plus 00:32:18 plus 0:49:31 = 02:36:59 (hh:nn:ss)
Etc.....
I hope I am making myself clear! If anyone could point me to a thread, or show me some code examples, I would really appreciate it. I am stuck! Meanwhile, I will keep pouring through the posts.
Thanks....
D
I have created an application for use in a production facility, for logging job and task progress, along with elapsed times. Operators "start" tasks, and "end" tasks with a click of a command button, or a swipe of a barcode scanner. The "start" or "end" action runs an append query that populates separate tables, using the time() function.
I then have a listbox, with a query for the source. The query uses both the start and end tables. In the query, I use:
Elapsed: Format([Start]-1-[End],"hh:nn:ss"
This displays the "elapsed time" correctly, if I was only concerned with displaying individual elapsed times.
However, I am actually trying to create an actual database of times that can be manipulated, and reported on. Totals, division for averages, etc. From what I can understand, searching through all the threads, Access is not really storing minutes and seconds, but reference points in a 24 hour cycle, even though you can format the results to "look like" elapsed times.
So I am assuming I am going to have to use VBA to achieve this goal. Specifically, I want to be able to take my "elapsed time" and divide it by whole numbers. For instance:
01:15:10 divided by # of doors equals X minutes and X seconds per door. (hh:nn:ss)
Or;
01:15:10 plus 00:32:18 plus 0:49:31 = 02:36:59 (hh:nn:ss)
Etc.....
I hope I am making myself clear! If anyone could point me to a thread, or show me some code examples, I would really appreciate it. I am stuck! Meanwhile, I will keep pouring through the posts.
Thanks....
D