I am looking to calculate the number of hours a volunteer worked, subtracted from breaks. Break time is a number field and am using the hours worked standard field. Please let me know any ideas on how to accomplish this.
Here is the formula I have right now. Thanks
(FLOOR(GW_Volunteers__Hours_Worked__c*60))- (FLOOR(MOD(break_time__c,60)))
5 respostas
Eric Praud (Activ8 Solar Energies) Forum Ambassador
HI Cindy, If GW_Volunteers__Hours_Worked__c is already in hours, simply go with this:
GW_Volunteers__Hours_Worked__c-break_time__c*60
Make sure you select "Treat blank fields as zeroes"