In a Db I have fields formatted for Date/time as follows MM/DD/YYYY HH:MM:SS
I need to calculate the time between two transactions. In Excel this is easy… it works. In Access, NO… I get #ERROR
How can I calculate the math between two time fields????
Fields are:
[CRL_HRL_WP_TIME]
[CR_OE_TIME]
[SH_TIME]
I need:
[CRL_HRL_WP_TIME]-[SH_TIME]