public class MyClass {
     public MyClass() {
        if(a=='New') {
         //Do Something}
        else if(a=='Old'){
         //Do Something
 }
}

public class MyClass {
     public MyClass() {
        if(a=='New') {
         //Do Something}
        else if(a=='Old'){
         //Do Something
 }
}

Hello,

I need to make a formula which will take a text field formatted like so: "0days 0hours 0minutes" and turn it into a number which could be output it in a stopwatch fashion: 00:00:00 so that I can use it to pull accurate reports.

I tried using the VALUE() fuction, but that did not seem to work.

Here is the formula that is generating the text field, if that helps at all:
 

IF(ISBLANK( Complete_Date_Time__c ) , "", 
TEXT( FLOOR(Case_Open_Length__c ) ) & " days " 
& TEXT( FLOOR( MOD( (Case_Open_Length__c) * 24, 24 ) ) ) & " hours " 
& TEXT( ROUND( MOD( (Case_Open_Length__c) * 24 * 60, 60 ), 0 ) ) & " minutes" 
)

Thank you.