• Calculate Date and Time

    Author
    Topic
    #1773974

    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]

    Reply To: Calculate Date and Time

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: