Quick question, the SLA is saving the minutes amount according to each calendar, but in somehow it saved the final hour in a regular time format?
I mean, If a ticket is created at 3pm and only have 2hours of SLA
I have to write 120 in solution time section on the SLA.
But in the database table "sla" is saving the 120 not the datetime and I need that final datetime. Any idea how can I get it?
I was thinking to take the amount and divided in 60 and then by 24. But If I apply an adddate() it wouldn't avoid weekend days.