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


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


      Calc 2


      This gives all values left of the decimal point


      Calc 3


      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.