Add together times

Forum|Forum|13 years ago
September 4, 2012
3 replies
1338 views

I am wanting to add together a series of stopwatch times, hours mins secs eg 00:10:22 + 01:44:03 = 01:54:25 etc there could be two or 3 or more. They are saved in mySQL as time.

Is this possable? Can be saved as different format if needed.

Cheers

This topic has been closed for replies.

H

headtoesAuthor

Participating Frequently

in the end did it by making two queries, one the usual and one using group by and sum, then did a query of queries using both of them

one small detail I havent worked out is how to take the seconds back to time format, at the moment Im using

this works fine but if there is a single digit it only displays one eg 1:1:1 whereas I would prefer to have 01:01:01

thanks for your help, wouldnt have been able to do it otherwise

H

headtoesAuthor

Participating Frequently

thanks for the replies, I have a slightly differnt problem now. I am grouping the times by the days they are made on. I can output the times seperately and they group by days ok but I cant think of a way to add them together. the code below gives me the total of all the times for all days and seems to ignore the grouping even tho it is within the cfoutput grouping tag. getting into and out of seconds seems no problem but Im out of ideas

SELECT date(UserQuiz.dateCompleted) as newdatecompleted, TIME_TO_SEC(userquiz.timespent) AS timespent

FROM userquiz

order by newdatecompleted desc

</cfquery>

<cfoutput> #times.timespent# </cfoutput>

#totaltime#

</cfoutput>

D

Dan_Bracuk

Inspiring

Look at the sql sum() function and group by clause.

H

headtoesAuthor

Participating Frequently

thanks, I was trying sql sum initialy but it was only bringing up one result, I couldnt work out why. I didnt realize there was a group by in sql. I guess if I use it there I dont need it in cfoutput? Anyway, will play around and see what results I can get