What i need to achive :
There is a value that is stored in the database ( call_req.time_spent_sum) this has a value in seconds
I need this value to be given as hours:mintues:seconds
so if call_req.time_spent_sum = 4830
i need to get 1:20:30
this is got by
3600 + 1200 +30
now after getting this value
i also have to get the sum of the amount of hr:min:sec spent on solving a particular problem in that day .
there are a few functions i have come across
Ive tried these but I am unsuccessful in getting the solution.