2 added 271 characters in body
source | link

You need DIV and % operators.

DIV is the integer division and % is the modulo function, returning the reminder:

SELECT 12345 DIV 60 AS hrs, 12345 % 60 as min;

UPDATE

You have to change your query such way:

SELECT
   . . . . .
   TIMESTAMPDIFF(MINUTE, Tickets.date, Tickets.solvedate) DIV 60 AS TempoH,    
   TIMESTAMPDIFF(MINUTE, Tickets.date, Tickets.solvedate) % 60 AS TempoM
   . . . . . 

You need DIV and % operators.

DIV is the integer division and % is the modulo function, returning the reminder:

SELECT 12345 DIV 60 AS hrs, 12345 % 60 as min;

You need DIV and % operators.

DIV is the integer division and % is the modulo function, returning the reminder:

SELECT 12345 DIV 60 AS hrs, 12345 % 60 as min;

UPDATE

You have to change your query such way:

SELECT
   . . . . .
   TIMESTAMPDIFF(MINUTE, Tickets.date, Tickets.solvedate) DIV 60 AS TempoH,    
   TIMESTAMPDIFF(MINUTE, Tickets.date, Tickets.solvedate) % 60 AS TempoM
   . . . . . 
1
source | link

You need DIV and % operators.

DIV is the integer division and % is the modulo function, returning the reminder:

SELECT 12345 DIV 60 AS hrs, 12345 % 60 as min;