Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
5 subscribers
Views
1605 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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....
OriginalPostID-75959
Discussion posts and replies are publicly visible
Parents
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
Reply
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
Children
No Data