I am hoping to accomplish having access calculate turnaround time, but I'm not sure it can be done with the way I set up my database.
I have the following fields: DateIn (system) and Timein(system) which time and date /time stamps when a request is entered. When the request is closed a completionDate is entered manually. Also manually a person calculates the turnaround time, based on 8 hours.
Is it possible / how would this be done to have access calculate the difference between the date and time of the request being entered and the completion date. I think I would have to enter a field for completion time, but how would the calculation be done?
I have the following fields: DateIn (system) and Timein(system) which time and date /time stamps when a request is entered. When the request is closed a completionDate is entered manually. Also manually a person calculates the turnaround time, based on 8 hours.
Is it possible / how would this be done to have access calculate the difference between the date and time of the request being entered and the completion date. I think I would have to enter a field for completion time, but how would the calculation be done?
