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
Just subtract the two dates. It will return an interval. That format is a bit weird, but you will find enough coding examples to parse it here.
a!localVariables( local!interval: split(userdatetime(2024,7,26,1,1,1) - userdatetime(2024,7,20,3,3,3), ":"), local!interval[1]*24 + local!interval[3] )
Thank you Stephen. But it should not consider weekend hours.
Eg: Start Date time : 07/26/2024 11:00AM
End Date time : 07/29/2024 11:00AM
should give us 24 hours. It should ignore weekend hours.