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
https://docs.appian.com/suite/help/25.1/fnc_date_and_time_calworkhours.html ?
calworkhours calculate only 9AM to 5PM ET, but i need to calculate 8:30 AM to 7PM
You wrote above "I have a working hours set to 8:30 AM ". What exactly do you mean by that? Where did you "set" this?
I didn't set yet but need to do so
OK, then I suggest to adjust the Appian process calendar to your working time and retry.
Hi anushak497885
You can set the working hours from process calendar.
I did that, it should calculate minutes not hours, calworkhours() will give hour difference not minutes right?
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".