Jump to content

Recommended Posts

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
https://forums.phpfreaks.com/topic/166341-add-times-for-a-total/
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.