Adding Times

[nuttycoder]

Hi I'm trying to figure out how to add times from from each row of a database and give a total time.

 

I have 2 columns in a table one called h which holds the hour and the second called m which holds the minutes.

 

I want to get all the hours and minutes from each row and add them to get a total time.

 

for instance I have this is my table:

  ID      h              m

1 03:00:00 00:10:00

2 04:00:00 00:10:00

3 01:00:00 00:19:00

 

so the final thing would be 08:39:00

 

Just not sure how to go about it.

 

[ignace]

$time = 0;
for (..) {
    $time += strtotime($row['timestamp']);
}

print date('r', $time);

[ldougherty]

I would suggest using the SUM function to total the columns of your database.  This will give you total hours and total minutes.

 

You could then (total hours * 60 + total minutes ) / 60 = total hours and minutes in decimal format