1 Reply Latest reply on Mar 28, 2014 8:59 AM by philmodjunk

    Duration Calculation for MM:SS

    SeanSteele

      Title

      Duration Calculation for MM:SS

      Post

           I'm having a hard time understanding how to set up time calculations. I would like to manually enter a duration in the form mm:ss and would like to multiply it by the number of reps to get a total duration. From the searches I conducted I was under the impression that the field could be set up as a time duration... but whenever I try to manipulate them they end up acting like a time as in 1:30 pm. Any help?

           Example:

           Duration = 1:30

           Reps = 3

           Total Duration = 4:30

        • 1. Re: Duration Calculation for MM:SS
          philmodjunk

               Duration * Reps will calculate a total duration in seconds. If you select a time result type, you can format the field on your layout to get a time format.

               but 1:30 is notation for 1 hour, 30 minutes, not 1 minute, 30 seconds. That may not be a major issue since you can use data formatting in the Inspector to use 24 hour format and the result will have the correct appearance even though it has computed the wrong value.

               Otherwise, you'll need to change either your data input or set up a calculation that first converts 1:30 into minutes and seconds before computing the elapsed time.