Suppose my working hour is 9 am till 6 pm....
1 ticket loged on 1st june at 3 pm..
and got resolved on 6th June at 11 am...
Time taken to resolve ticket :
1st june = 3 working hours (3 pm to 6 pm )
2nd june = 9 working hours
3rd june = 9 working hours
4th june = 9 working hours
5th june = 9 working hours
6th june = 2 working hours ( 9 am to 11 am )
For me it took 41 working hours to resolve.
Is there any formulae in Excel.
So that I can put Logged date and time and resolved date and time
And get no of hours given to ticket during working hours.