I am trying to create a custom field that will calculate the aging of a lead. In our business speed to responding to a lead is critical so we measure it in terms of Days, Hours, Min. I created the following formula which accurately calculates the Lead Aging in decimal form:
Datecomp(Now(),${Leads.Created Time})/1440
The problem is I need to convert the decimal form into Days, Hours, Min. (ie:3.5 = 3 Days 12 Hrs 0 Min)
I am able to correctly calculate the Days by the following formula:
Tostring(Floor(Datecomp(Now(),${Leads.Created Time}))),' Days '
Unfortunately, it does not appear that Zoho has a Mod() function available for use for custom fields. This would give me the remainder of a number after it has been divided by a divisor. Does anyone know a way around this? I used this method successfully in Salesforce a while back but they had the Mod() available.
Thanks