I have a working hours set to 8:30 AM to 7PM EST, it should calculate only these hours for business days and remaining non working hours or non business days should not calculate.Example: requests submitted only calculate from monday-friday 8:30 AM to 7:00 PM ET.
Earlier we had a plugin called calendar functions but now its archived, is there any other alternative way to do?
Discussion posts and replies are publicly visible
Hi anushak497885
You can set the working hours from process calendar.
calworkhours( gmt(datetime(2025, 04, 17, 08, 30, 00)), gmt(datetime(2025, 04, 17, 19, 00, 00)), "ET Calendar")this should give 10.5 hours which is (630 minutes) but its giving 11 hours.
As per the documentation, this function returns an integer number. If this does not fit your requirements, you might have to look for a plugin.
If you want minutes there is plugin available called "Calendar Functions" in that you have a function called "calworkminutesplugin".
This plugin is deprecated and should not be used anymore.
you’re right it’s deprecated and we can’t use that plug-in. Any alternative way?
I found this thread, see if you can use it
https://community.appian.com/discussions/f/general/28432/calculate-business-hours-minutes-between-two-date-time