I have a overview of hours worked by colleagues but for some reason the hours worked on Sunday are not added in the total amount worked hours in that week.
Any suggestions?

Click image for larger version. 

Name:	Knipsel.PNG 
Views:	4 
Size:	47.0 KB 
ID:	16521

TIME_FORMAT(SEC_TO_TIME(SUM(TIME_TO_SEC(eind) - TIME_TO_SEC(start) - TIME_TO_SEC(pauze))), '%H:%i') AS week_totaal
FROM users_uren
WHERE user_id = ".$user_id." AND WEEKOFYEAR(datum) = $week AND YEAR(datum) = $year
GROUP BY WEEK(datum) , YEAR(datum)";
Help is much appreciated.