GLese
Registered User.
- Local time
- Today, 10:00
- Joined
- Feb 13, 2018
- Messages
- 52
The database I am designing needs to be able to calculate the turn around time (T.A.T.) on samples being processed.
Each record in the main table will have a lot of data for each sample, but the times that are being recorded are in three fields: DateIn (Will autopopulate when the record is created using =Date()), TimeIn (Autopopulates with =Time()), and DateTimeOut (Autopopulated as a General Date format using =now() when the record is modified).
We calculate T.A.T. (in hours) = DateTimeOut - (DateIn + TimeIn) (excluding hours outside of 8a-5p M-F)
Would this be better done through a calculated field? Query? SQL?
Any direction and nudge towards the right coding would be appreciated!
Each record in the main table will have a lot of data for each sample, but the times that are being recorded are in three fields: DateIn (Will autopopulate when the record is created using =Date()), TimeIn (Autopopulates with =Time()), and DateTimeOut (Autopopulated as a General Date format using =now() when the record is modified).
We calculate T.A.T. (in hours) = DateTimeOut - (DateIn + TimeIn) (excluding hours outside of 8a-5p M-F)
Would this be better done through a calculated field? Query? SQL?
Any direction and nudge towards the right coding would be appreciated!