Calculation Time Differences

Assumptions:

-Multiple Jobs can be peformed in one day (queiries must be able to display all jobs performed on a selected day)

-Multiple Delays will occur within each job.

Crucial Form Fields:

-Date, ProductionStartTime, ProductionEndTime

Crucial SubForm Fields (To Enter Production Delays):

-DelayStartTime, DelayEndTime, DelayReason

Goals:

-Calculate the Production Time by subtracting ProductionStartTime from ProductionEndTime.

-Calculate Delay Minutes by subtracting DelayStartTime from DelayEndTime

**Key Problem** Ex. A Job may begin on Oct 1 at 5AM and end on Oct 2 at 1AM

I think you're going to have to combine the date and time values in your tables and input forms or add them on the fly to do the calculations...


ken

Have a look at this thread. It may help. I use the hoursandminutes function in one of my applications and it works well. I am sure it will help you to find a solution to your problem.

http://www.access-programmers.co.uk/forums/showthread.php?t=84990&highlight=hoursandminutes

Ken is exactly right; in order to use the DateDiff function, which is how you calculate differences in dates/times, you really have to have the date and time! You can concatenate the time and date to get a valid date for use in the function, but it probably would be simpler, depending on your requirements, to enter it all at once.

Linq

Attached is the database objects that the time problem is dealing with. I would really appreicate it if one of you brilliant access minds could solve the issue. A Job can start and end on different days, and numerous delays can occur within that job. The delays can obviously also start and end on different days. Ideally, I would like the start/stop times of both the job and the respective delays to all be linked to the product date so that I can query by dates to view the various jobs. Also, that would eliminate the data enterers from having to enter the time and date for each individual delay.

Again, if anybody is willing to try and make this work, I would greatly appreciate it.

Thanks