75959 - no subject - I have two pvs called startDateTime and

ambrishs over 10 years ago

I have two pvs called startDateTime and endDateTime. I am interested in getting duration by subtracting startDateTime from endDateTime. But at the same time I also want to account for weekend hours. Like if start time is say Aug 2nd(Friday) 3 PM and end time is Aug 5th(Monday) 11 AM, and my regular working hours are Monday 8 AM - to Friday 5 PM, the result should be 5 Hrs only. Is there any function available to achieve such thing.
Thanks....

Discussion posts and replies are publicly visible

0 shrutij over 10 years ago

Hello, The answer to your question can be answered in 2 parts, 1. One would need to set the working hours (in your case 9 hours) in the System calendar by going through the following link
forum.appian.com/.../System_Calendar_Settings
(Please note if you have to set the time for all each of the days through out the calendar you need to click/select the S-M-T-W-T-F-S to set it, it will be set for the whole calendar and not just the month where you are making the change)

2. Once the above change is done you can use the following expression
calworkhours(start_datetime,end_datetime)

Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 10 years ago

Is this for a process or a task. I would suggest you take a look at Task Metrics category under 'Data' tab as it contains lots of rich functions to calculate Lag, completion duration etc., You can combine these with the expressions to get an even richer reporting.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel