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
Manoj Goswami 5Manoj Goswami 5 

How to convert total minutes into Days Hours and Minutes using formula editor

I have total minutes calculated (total_minutes__c),
How to convert these minutes in Days, Hours and Minutes.
I want something like this :
eg.
Input: total_minutes__c = 12495
Output = 8 Days 16 Hours 15 Minutes 

Thanks in advance.
Jothi SaminathanJothi Saminathan
Hi Manoj,
   
 Please try this below formula:

 TEXT(FLOOR( Total_minutes__c / 1440)) &'Days'& TEXT( FLOOR( MOD(Total_minutes__c,1440 )  / 60)) &'hr'& 
TEXT(FLOOR(MOD( MOD(Total_minutes__c,1440),60)))&'min'     
 

Thanks,
Jothi
Sweet Potato Tec.