Converting Time

Hi All,

I am currently working on a website which has a form, the form sends some details into a table called 'reports'. It assigns a variable for the current total hours (which is located in a table called 'pilots') and then takes 1 field from the form (Duration) and adds it to this variable number (TotalHours). It then updates the TotalHours in 'pilots' with the new total hours. The problem is that we have to convert the duration into decimals each time we fill in the form, how do I change the times (00:00:00) into decimals(00.00), add the two decimals together and then convert it back into a time format(00:00:00) for when it is shown on a roster page using PHP/MYSQL?

Any help much appreciated, if you want access to the code just say and I will send it over. Or if you don't understand a word I just typed, I can have a go at making it a bit simpler:P

Mike

There shouldn't be a conversion to decimal, use the date and time functions already built in to mysql. Here's a link to the ADD part:

http://dev.mysql.com/doc/refman/5.0/...nction_addtime