Code:
SELECT
id,
user,
kommen,
mittaggehen,
mittagkommen,
gehen,
((UNIX_TIMESTAMP( gehen ) - UNIX_TIMESTAMP( kommen )
) - ( UNIX_TIMESTAMP( mittagkommen ) - UNIX_TIMESTAMP( mittaggehen ) )
) AS zeit,
SUM(((UNIX_TIMESTAMP( gehen ) - UNIX_TIMESTAMP( kommen )
) - ( UNIX_TIMESTAMP( mittagkommen ) - UNIX_TIMESTAMP( mittaggehen ) )
)) AS zeitzusammen
FROM `zeitkarte`
WHERE user = 'dani'
LIMIT 0 , 30