Keeping track of Time.....

[kanjeep]

I'm trying to add a couple of fields to my database that will keep track of what time production jobs should complete for a specific machine. I have fields for cycles, minutes per cycle and what time the machine starts. I want to take the total of cycles*minutes and add this time to the start time and show on the report what time the job will complete. Any ideas?????

 

[Fifty2One]

To calculate the termination of a times sequence in production here are the numerical values for time according to Microsoft's clock...
1 1 day
0.333333333333333 8 hours
8.33333333333333E-02 2 hours
4.16666666666667E-02 1 hour
2.08333333333333E-02 30 minutes
1.04166666666667E-02 15 minutes
6.94444444444444E-03 10 minutes
3.47222222222222E-03 5 minutes
0.000694444444444553 1 minute

...sorry I dont have the break down below a minute...

 

[pbaldy]

Since you have the number of minutes, it would be simple to use the DateAdd() function to add that number of minutes to the start time.

 

[kanjeep]

I had tried just adding the total minutes to the start time, but it only showed it broken down to hours, not minutes so the total was incorrect. 'M' = month, 'D' = Day, 'Y'=Year, 'H'=Hour and 'Q'=Quarter.

 

[boblarson]

'n' = minutes