Hello All,
We need to calculate number of hours between two date and time values. and this should not consider weekends.
Thanks in advance
Discussion posts and replies are publicly visible
You could try using the calworkhours function.
docs.appian.com/.../fnc_date_and_time_calworkhours.html
Thank you Mathieu Drouin, this considers only week hours. But my use case is only not to consider weekend hours.
If so , Use Stefan's logic ,but somehow you need to find out how many weekdays are there or In default working calendar weekends are considered non working days , So use calworkingdays() .
a!localVariables( local!workdays:calworkdays(ri!startTime,ri!endTime-1), (hour(ri!endTime-ri!startTime)+local!workdays*24) )