Forum Discussion
Solved
Calculate Work Hours/Network Hours Exlcuding Weekends SIMPLIFIED
Hey DataFam, Took me a while to sift through different ways to calculate working hours/network hours and this was the simplest implementation I made up myself. Step 1 Create a calendar tabl...
SOLVED ABOVE! Let me know if you have any questions!
Hi,
This worked as a charm and was th easiet way as compared to all the solutions I have seen.
What I was hoping to do is it to exclude public holidays (Have a table called public holidays with dates in them
&
Where there is no [end date] it should take it as now (I have a table where the date/time for now is captured)
&
Where [end date] is lesser than [start date] it should consider it as 0 mins.
Any help will be apprecated