You need to sign in to do that
Don't have an account?
Brian Roberts 2
Formula for breaking a 24 hour day into 15 minute increments.
I would like to divide a 24 hour day into 15 minute increments so a time worked can be selected from a picklist value and multiplied by the daily rate to get a total cost. the picklist is broken down into 15 minute increments as follows 00:15, 00:30, 00:45, 01:00, 01:15 and so on. Can anyonr advise me on the best way to do this?
if(CONTAINS(TEXT( Date_Start_Time__c),":"), -1 +(24-value(left(text(Date_Start_Time__c),2)))/24 ,0)
+
if(CONTAINS(TEXT( Date_End_Time__c),":"), -1 + value(left(text(Date_End_Time__c),2))/24 ,0)
Then to calculate the total the following was used:
MAX(Date2_End__c + 1 - Date2_Start__c + Calc_Qty_Partial_Days_Formula__c,0)