SUM(times) in hours and minutes

[unistake]

Hi all,

I have several times in a mysql database stores as 00:25:00 = 25 minutes.

I am trying to add all the times up in a column under 'times' and show an output of 05:45  = 5 hours and 45 minutes (for example).

 

So far I have got...

<?
$query1 = "SELECT SUM(times) FROM logbook WHERE reg='1234'";
$result1 = mysql_query($query1) or die(mysql_error());

while($row = mysql_fetch_array($result1)){ 
   echo $row['SUM(times)'];
    echo $totalic;
}

?>

 

The output I get from the above $totalic is something like '34500'. - How can I convert this to 05:45 for example.

 

Thanks for the help guys

 

[The Little Guy]

I found this on the mysql time page:

 

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `time` ) ) ) AS total_time FROM time_table

[unistake]

thanks little guy,

could you write this into my script above? That has totally lost me!

 

[The Little Guy]

<?php
$query1 = "SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(`times`))) AS total_time FROM logbook WHERE reg = '1234'";
//$query1 = "SELECT SUM(times) FROM logbook WHERE reg='1234'";
$result1 = mysql_query($query1) or die(mysql_error());
$row = mysql_fetch_assoc($result1);
echo $row['total_time'];

/*
while($row = mysql_fetch_array($result1)){ 
   echo $row['SUM(times)'];
    echo $totalic;
}
*/
?>

[unistake]

You are a legend!

 

Works as it should, put my hours of attempts to a finish, thanks Big Man!