Last post Aug 20, 2010 03:51 AM by gaurav_majithia
Aug 19, 2010 09:01 AM|gaurav_majithia|LINK
I have tried searching all over the internet, but no luck. :(
Got many logics but not able to integrate in my logic or you can say I am bad at write logical codes.
I want to calculate the ticket resolution datetime excluding Holidays and Weekends and non-working hours.
my working hours are 3.00 to 18.00 and we dont work on Weekends and few holidays.
Can someone please help me with the code for this??
It would a great great help.
Aug 19, 2010 09:51 AM|tecktree|LINK
Are you looking for something like this?
Aug 20, 2010 03:51 AM|gaurav_majithia|LINK
Actually what i want is User will supply Incomming request datetime.
According to the the priority I will set some hours in which the request has to be completed and I ahve to show the user target datetime or you can say resolution datetime.
Can you please help me with this logic.
Incomming datetime = 18/08/2010 13:30:00
Number of Hours in which request should be completed(SLA) = 9
Working hours> 12:30:00 to 21:30:00
Calculated Target Dattime> 19/08/2010 13:30:00
Means 8 hours shoudl be taken from same date as its still under working hours, 1 hour will go on next day after shift starts.