Calculating the difference between two times RRS feed

  • Question

  • Hi All;

    I'm writing a database to manage a canoe/kayak race event.  The problem that I'm having is creating a calculated field that can calculate elapsed time using a 24 hour clock.

    The three fields that I'm using are: Start Time - Finish Time - Elapsed Time.  All need to be entered in 24 hour time.  An example would be;

    Start Time - 08:01:00

    Finish Time - 10:01:23

    Elapsed time - 2:00:23

    Every time I create a calculated field, I always get the result back showing AM or PM at the end of the equation.

    Can someone point me in the right direction to find some documentation on this, or can I get some help with this?

    I appreciate your help with it.

    Friday, February 26, 2016 2:37 PM


All replies