If I input: Quantity = 10
Duration_minutes = 180
Duration Seconds = 600
$results = sql::clean_row("
SELECT
quantity,duration_minutes,
duration_seconds
From event.dbo.process_data");
echo $results['duration_minutes'] . " " . $results['duration_seconds'] . " " . $results['quantity'] . "<br />";
echo $total_duration =(($results['duration_minutes'] * 60 + $results['duration_seconds'])/60) / $results['quantity'];
echo round($total_duration, 1) . " - Time <br />";
echo ROUND($total_duration);
My output is:
1919 - Time
19 < rounds back to 19.
I'm not happy with the seconds output though, it's roughly 600 to every minute... how should i go a fix to get back to 60 seconds is every minute?