function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
pavan kumar 177pavan kumar 177 

How To Summarize in HH:MM:SS of call duration

Hi friends i got a requirement to summarize call duration.So,I created a custom field with Call Duration(Minutes). 
IF((MOD(CallDurationInSeconds/60,1)*60) > 10, VALUE(TEXT(FLOOR( CallDurationInSeconds/60)) + "." + TEXT(FLOOR(MOD( CallDurationInSeconds/60,1)*60) )), VALUE(TEXT(FLOOR( CallDurationInSeconds/60)) + ".0" + TEXT(FLOOR(MOD( CallDurationInSeconds/60,1)*60) )) )

Now i am able to summarize but it's showing everything in minutes like for 1 hour 50 minutes.It's showing 150.Please i want like in hours and minutes format.
pavan kumar 177pavan kumar 177
For 1 hour 13 minutes it' showing like 73 minutes