1 of 1 people found this helpful
I know there is an easy way to get the first day. Not sure about the last one.
This calc will do it though
Edit, which is exactly what Dana posted. I had misinterpreted the text....
HI Alex ,
I am stuck in issue i need help
I want to count hours difference between two dates on two cases
1) count hours for only working hours (8am-5:30 pm)
2) exclude weekdays (Saturday, Sunday )
For example if an order is placed at 10/2/2013 and filled on 10/5/2013 .
Then time difference will be 12 minutes.
Please help me in this issue , i am trying different cases and following your posts regarding weekdays but not getting exact solution.
Are the two dates on the same row in the raw data?