4 Replies Latest reply: May 15, 2014 9:57 AM by Nick Osdale-Popa RSS

    Elapsed Time / Time Span format

    Nick Osdale-Popa

      In my table I have this:

      [font="courier"]StartTime                 EndTime                   Elapsed

      2005-08-16  6:30:01 PM    2005-08-16  6:32:17 PM    00:00:00

      2005-08-16  8:00:00 PM    2005-08-16  8:19:53 PM    00:00:00

      2005-08-16  9:10:00 PM    2005-08-16  9:10:50 PM    00:00:00

      2005-08-22  6:45:01 PM    2005-08-22  6:48:45 PM    00:00:00

      2005-08-22  7:00:01 PM    2005-08-22  7:00:03 PM    00:00:00

      2005-08-22  7:15:00 PM    2005-08-22  7:16:02 PM    00:00:00

      2005-08-22  7:30:00 PM    2005-08-22  7:30:09 PM    00:00:00

      2005-08-22  7:45:00 PM    2005-08-22  7:45:36 PM    00:00:00

      2005-08-22  8:30:00 PM    2005-08-22  8:36:42 PM    00:00:00

      2005-08-22  9:35:00 PM    2005-08-22  9:35:13 PM    00:00:00

      2005-08-22  9:40:01 PM    2005-08-22  9:41:00 PM    00:00:00

      2005-08-22  9:45:01 PM    2005-08-22  9:45:17 PM    00:00:00

      2005-08-22  9:50:01 PM    2005-08-22  9:52:31 PM    00:00:00

      2005-08-22  9:55:01 PM    2005-08-22  9:55:21 PM    00:00:00

      2005-08-22 10:15:00 PM    2005-08-22 11:14:50 PM    00:00:00[/font][/quote]EndTime (and StartTime)

      Type: Date/Time

      Format: Short Date & Time

       

      The Calculation for Elapsed is:

      Type: Numeric  Decimals: 0

      Format: Time Span

      Formula:

      EndTime - StartTime

       

      yet as you can see I'm only getting 00:00.

       

      This is my first time trying to calculate time, so I'm not sure what I'm missing.

       

      Forgot to mention: Version 8 Monarch.