Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate Date and Time

    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]
    There is always a way.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    1,156
    Thanks
    100
    Thanked 136 Times in 121 Posts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •