Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Problem : I need to calculate time difference between two successive date in a column(It is a DateTime field i.e. 'MM/DD/YYYY hh:mm:ss') excluding weekends/holidays.
So, I have got the difference between the two successive dates and calculated the number of weekends/holidays in between as well. Now I was thinking the next part should be pretty easy as I will just multiply the number of weekends/holidays by 24 and subtract it from the original difference that I have got but for some reason I am not getting the desired result. I have tried Time/Time# functions but it does not seem to work. I know if I can convert the (number of weekends * 24) value into Time format(hh:mm:ss) , I can easily subtract it from the original difference. I am kinda stuck here so any help will be very useful at this moment.
Thanks,
Pranav
I guess you could simply subtract your number of weekends/holidays (x) from the difference like :
Interval(Date1-Previous(Date1) -x,'hh:mm:ss')
and that should work.
Could you clarify (possibly with an example)- what you have now (after some calculations) and exactly what you want out of it ?
I guess you could simply subtract your number of weekends/holidays (x) from the difference like :
Interval(Date1-Previous(Date1) -x,'hh:mm:ss')
and that should work.