nuttycoder Posted July 17, 2009 Share Posted July 17, 2009 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. Link to comment Share on other sites More sharing options...
ignace Posted July 17, 2009 Share Posted July 17, 2009 http://www.phpfreaks.com/forums/index.php/topic,260897.msg1228269.html#msg1228269 Link to comment Share on other sites More sharing options...
Recommended Posts