i have some data which is coming as: 0.00000 37.17000 60.00000 60.00000 34.47000 now i am trying to get the time as how many minutes and seconds, so i am seeing it 194.04, i tried with mysql and with coldfusion both but i am always ending up with 194:11 my mysql solution is

SELECT
    CONCAT(
        FLOOR(total_seconds / 60),
        ':',
        LPAD(MOD(total_seconds, 60), 2, '0')
    ) AS total_time
FROM (
    SELECT
        SUM(
            CAST(SUBSTRING_INDEX(mind, ':', 1) AS UNSIGNED) * 60 +
            CAST(SUBSTRING_INDEX(mind, ':', -1) AS UNSIGNED)
        ) AS total_seconds
    FROM
        stats
    WHERE
        ID IN (174)
) AS subquery;

my cf solution its totally wrong https://trycf.com/gist/6963fed15361103dc8780febec71c0a3/lucee5?theme=monokai

It is this line in your function

var seconds = val("0." & parts[2]) * 60;

By the look of your question and your SQL, you're treating the 2nd part of your data as the second itself But in your function you are making them as decimal and then multiply them by 60 So 0.17 should be 17 seconds, but you are doing 0.17 * 60 (so you are treating 0.17 as 0.17 minute, not 17 seconds) Change it to multiply by 100 should fix it Or just

var seconds = val( parts[2] );

and same with sql

I maybe lacking coffee, but your last gist you have seconds multiplied by 100, plus you are treating strings as numbers, which I am very guilty of, but its not the greatest. Try this instead: https://trycf.com/gist/76c67b824f8a30d8e4fb92a09ba6ab19/lucee5?theme=monokai

answer should be 192.04 but the answer i am seeing with your gist is: 64191.00

I was under the impression that is what you where trying to do, but it looks like there is a conversion issue. Grabbing the seconds value without doing a massive conversion appears to work.

odd part i was not understanding why it was not splitting 64 into 60 + 4 as extra seconds

It's a low-level code of logic where time units range from 0 to 60. 😕

in mysql, i was able to reach 191.38, not sure it suffers same fate, even not sure if yyou are good in mysql, if yes, you can help me out else no worries