4 Replies Latest reply on Feb 14, 2012 8:35 AM by Kristian Desch

    Merging 2 Strings With Time Formatting

      I'm working on a computing average pace (minute/mile) after collecting distances and times. I believe to have all of the calculations figured out but am coming up short on final formatting (I believe).

       

      Here is what I have so far-

       

      Calc 1

      ROUND([Minutes]/[Distance],2)

      This returns a figure like 8.45 minutes -  not the 8:27 I'm seeking.

       

      Calc 2

      FLOAT(LEFT(STR([Min/Dist(rounded)]),FIND(STR([Min/Dist(rounded)]),".")-1))

      This gives all values left of the decimal point

       

      Calc 3

      (FLOAT((MID(STR([Min/Dist(rounded)]),FIND(STR([Min/Dist(rounded)]),".",1)))))*60

      Grabs the digits right of the decimal and then converts to seconds

       

      Calc 4 (Where I've hit a roadblock)

      I was hoping to combine the strings and then format as minutes:seconds but this has proven to be more difficult than I anticipated. Is there a better approach than what I took above?

       

      Thanks in advance.

      Jacob