Merging 2 Strings With Time Formatting

tableaucommunity@tableau.com — Tue, 14 Feb 2012 16:35:23 GMT

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

Content in Tableau Community Forums

Merging 2 Strings With Time Formatting