duda sumar el total de una diferencia de minutos

[leonardo_josue]

Hola Markgus:

Puedes hacerlo de dos formas:

Código MySQL:

SELECT T.*, DifUno+DifDos+DifTres total FROM
(
SELECT 
Num,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') DifUno,
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') DifDos,
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') DifTres
FROM MiTabla where Num = 8 and campo_fecha > current_date
) T
 
SELECT 
Num,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') DifUno,
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') DifDos,
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') DifTres,
timestampdiff(Minute,'2011-05-30T10:00:00','2011-05-30T10:15:00') +
timestampdiff(Minute,'2011-05-30T15:00:00','2011-05-30T14:50:00') +
timestampdiff(Minute,'2011-05-30T18:00:00','2011-05-30T18:00:00') total
FROM MiTabla where Num = 8 and campo_fecha > current_date
 

Haz la prueba y nos comentas.

Saludos
Leo.