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

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.

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

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.

"EmanJR" wrote in message
...
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.