Forum Discussion
Solved
Networking hours in a week
Hi thanks for the last solutions.
i was able to calculate the net working hours for a month ,but i need to calculate networking hours in a week.
formula i used , shown below.but getting wrong answer . I have holiday calendar table and my calendar table is workdate
please help me to find solution
ashik1992 , Create a new column in date table
Switch([Workday],
"Holiday" ,0 ,
"Flexi" ,2.5 ,
8
)
and use that
1 Reply
ashik1992 , Create a new column in date table
Switch([Workday],
"Holiday" ,0 ,
"Flexi" ,2.5 ,
8
)
and use that