You need to sign in to do that
Don't have an account?
lapaul
How to calculate total minutes into hours
Hi,
Is there any formula to convert or calculate total minutes into hours? I have a custom field that stores
total minutes and I want to convert this into hours. Any help would be appreciated.
thanks
Paul
Uhhh....
Minutes/60?
I really envy your sense of humor, werewolf.
ThomasTT
I placed a custom number field in Activities. It is called Activity Duration in Minutes. When I run a report, I get the sum of all the minutes at the bottom. I would like it to be displayed as hours and minutes. I tried the formula below and I keep getting errors, (I got this out of SFDC help and training). Is this formula supposed to go someplace else? Or, am I doing it wrong?
Thanks.
Kimberly J.
FLOOR((Activity.Activity_Duration__c:SUM)/60)
&"Hour(s)"
&MOD((Activity.Activity_Duration__c:SUM)/60,1)*60
&"Minutes"
You cannot make a formula field that converts minutes to a human-readable hours and minutes (like 4:35) and sum that. Once it becomes "4:35" it is text and cannot be summed.
As such, there's really no combination of formula fields you can add to the Activity object itself that would produce the desired effect.
The only real way to do what you want to do is create 2 custom summary fields on the report. The hours formula would be like:
FLOOR(DURATION:SUM/60)
The minutes formula would be:
MOD(DURATION:SUM,60)
These would be custom summary formulas, so you'd actually add them in step 2 of the report wizard to a Summary Report, not to the Activity object.
ok, but I just want the readable #hours #minutes format on the report, not in the activity. I'm happy with 75minutes in an activity. When I run the report on all the activities of all the minutes, no decimals, I want the bottom row to say #hours, #minutes. is that possible?