Adding time

[Anon]

Working on a race program. running , biking, swimming, and need the proper way to add time from a database, MySQL.

the fields are

Running = 52mins

Biking = 15mins

Swimming = 15mins

Total = 1.366 hours for Joe Brown

Any good tutorials on adding time using PHP and MySQL ?

Cheers

[Anon]

well you could just add the minutes and divide them by 60.

[Anon]

How are the values for minutes stored in the Database?

if thet are just numbers why not...

SELECT SUM((running + biking + swiming) / 60) AS TOTAL FROM table where....

echo "Total = " . $TOTAL . "hrs for Joe";

[Anon]

Yes they will be numbers. So I will use FLOATS correct?

[Anon]

Thanks works great!!