Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have two date fields like below. From these Two date please help me to calculate the Time Difference in Working Minutes.
A “working minute” is defined as any minute that falls between the hours of 09:00 and 17:30 on any Monday, Tuesday, Wednesday, Thursday or Friday that is not a bank holiday date in England in the relevant year.
Please help me on this.
Thanks in advance
networkdays(Currdate, Adddate,vHolodays) * 24 & Interval(time(frac(Currdate))-time(frac(Adddate)),'HH:mm')
Hi @Channa
Thanks for your help.
Could you please explain the below logic why its included in the expression. When I have taken below part in a separate expression I am getting 0's
networkdays(Currdate, Adddate,vHolodays) * 24