display time durations on a chart

[Yumster]

I am creating a stacked line chart from a helpdesk database using speed_of_answer, avg_talk_time, pct_abandons.
I have created the chart and can display speed_of_answer & avg_talk_time ( for example avg_talk_time is 6.25 sec but they actually want the data label to be displayed as 6:15 sec ). I created a formula to format this data as requested but when I try to chart it with the pct_abandons the pct_abandons charts correct but the avg_talk_time when formated as 6:15 just creates a line with the value of 1.
How can I get the duration time displayed as mm:ss?

 

[h0h0h0]

i have a hack idea for this but it's prob not what you're looking for.

format the 6:15 value into a number by replacing the : with a decimal and putting a to_number on it. then chart the output of this new formula.

 

[Yumster]

Thanks h0h0h0.. I like this idea. Now hopefully the end-user will buy off on this. So simple I couldn't see the tree for the forest. Thanks again.