Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|