Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG

[Guest]

I am Doing a Call log of Every Single Phone Call that i make, and i am
calculating that through Minutes and Seconds. For an Example 1 Call take 3m
30s to Complete, and the Other Call Takes 6m 45s To Complete. What i need is
a Formula that will take all the Times that i log in Calls Add the Minutes
and the Seconds, and give me a Result of the total Hours/ Minutes/ Seconds
Spent on the phone. For an Example of the Results i would want to see is.
15 Calls Each a 5 Minutes per Call would come to 75 Minutes. What i want the
formula to be able to do is take that and add the times according to the 60
Minutes = 1 Hour Rule, and 60 Seconds = 1 Minutes Rule. What i want to see
as the result would be 1hr 15min 00sec. Please Help me with this, it would
make it so much easier to do my calculations. Any questions let me know.

 

[Guest]

Hi

If the times are entered correctly (hh:mm:ss) then you can use the SUM
function to add the times. Format your result as [hh]:mm:ss

Andy.