Skip to main content

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
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    4 de abr. de 2021, 09:36
    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"

     

     
0/9000