adding time

cougarhockey

I have a table which one of the columns holds a time value in the format hh:mm:ss and I want to add all of these time columns to come up with a TOTAL time taken.
for instance 01:45:25 + 02:20:10 + 02:10:50 etc.
how can i add these together and have the output be hh:mm:ss because right now with that example above it will add it as if the numbers were 014525+022010+021050=57585 when the answer i'm looking for would be 6:16:25

i'm sure i need to do some converting but my brain is fried from class so i can't think right now

thanks

YappyDog

Convert them all to seconds, add them all together, then break them back out into hours, minutes, seconds.

kumschick

Convert the time into seconds and count everything together and then back to hours, minutes, seconds!

to convert it back from seconds to the time use:

$time["hours"] = floor(($time / 3600));
$time["mins"] = floor(($time - ($time["hours"] 3600)) / 60);
$time["secs"] = floor(($time - ($time["hours"] 3600) - ($time["mins"] * 60)));

cougarhockey

i'm fairly new with PHP, what would be an easy way to go from the hh:mm:ss to all seconds? I understand how to go back once you have it all in seconds but how do you tell it to take the number in the hh place and multiply it by 3600, then take the numbers in the mm place and multiply it by 60, then add both of those to the ss?
should i put each of them into an array?

goldbug

If it's already in a MySQL database, save yourself the unnecessary burden of converting anything.

Specifically, the DATE_ADD, DATEDIFF, ADDTIME, ADDDATE, and TIMEDIFF functions. They can come in very handy in situations like this.

cougarhockey

yea it's already in the MySQL database...
that link is looking to be exactly what i needed

thanks!

cougarhockey

ok still having problems...
I'm trying to use the TIME_TO_SEC function and here is my code

<?
include("db.php");
$result=mysql_query("SELECT time_to_sec('10:10:10')");
echo "$result<br><br>";
?>

just to use as a test to see if it works and well i get a Resource ID #4 error when i run this...i searched online and found a few places that said you have to add mysql_fetch_array then the rest of the mysql_query string and when i did that my output was "Array"

i don't know much at all about mysql...any ideas please?

in the broad scheme of things i'm trying to create a site that people who work out can log onto and put in how long they worked out etc...
well i want to add up all their times so they know how much they have worked out in the past week, month, year
and i'm having horrible troubles trying to take the times off the database and add them up

thanks