DiffWorkingSeconds

returns the number of working seconds between two datetime values syntax diffworkingseconds(hopidorname, utcstart, utcend) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) no business rules calculation rules (before save or always, with recalculate on load) no business rules editing rules yes1 business rules initialization rules yes business rules read only rules no business rules required rules yes1 business rules validation rules yes client expressions no object permissions no services yes ldap yes mobile yes quick actions (except ui quick actions) yes ui quick actions no reports yes search/dashboard without field references yes search/dashboard with field references no 1 except when this field appears on a form or is triggered by such a field parameters parameter description hopidorname the hours of operation schedule name (for example, 24x7 or 9 to 5) that determines the working and non working schedule see setting up hours of operation docid qp9oyhxnf2bf5fnn2nex utcstart the start date and time to be compared utcend the end date and time to be compared returns value number value if the value of the startdatetime parameter is earlier than the value of the enddatetime parameter, the returned value is positive if the value of the startdatetime parameter is later than the value of the enddatetime parameter, the returned value is negative example $(diffworkingseconds("24 x 7", "4/5/2015 11 36 am", "4/6/2015 11 36 am")) returns the number of seconds in a working day, which in this case is 28,800 seconds (8 hours x 60 minutes x 60 seconds), assuming that there are no exceptions during that time defined in the hop schedule