1 Reply Latest reply on Dec 16, 2014 7:54 AM by philmodjunk

    Calculating time elapsed between time fields

    AlexOrrow

      Title

      Calculating time elapsed between time fields

      Post

      Hi,

      Is there a method to calculating the time elapsed between different time fields in separate records? I am logging sleep and wake times as well as activity times and wanted to create durations between a sleep time, waking time and activity time. Many thanks for any guidance.

       

       

       

       

       

        • 1. Re: Calculating time elapsed between time fields
          philmodjunk

          Elapsed time in seconds can be computed by subtracting the start time from the end time or (better) the start timestamp from the end timestamp. Divide that value by 60 to get minutes and so forth...

          These can be values in two different records provided you can reference the correct record for one of the two values. This can be established with a relationship or possibly through the use of the GetNthRecord function.