Salesforce/Administrator
[수식] 경과시간 ([Formula] Elapsed Time)
어디다쏨
2022. 6. 8. 23:01
728x90
IF(
EndDate__c - StartDate__c > -1 ,
LPAD(TEXT( FLOOR( MOD( (EndDate__c - StartDate__c ) * 24, 24 ) ) ), 2, "0") & ":"
& LPAD(TEXT( FLOOR( MOD( (EndDate__c - StartDate__c ) * 24 * 60, 60 ) ) ), 2, "0") & ":"
& LPAD(TEXT( ROUND( MOD( (EndDate__c - StartDate__c ) * 24 * 60 * 60, 60 ), 0 ) ), 2, "0"),
"-"
)728x90