calculate hours worked per week

[#1]

hello all stp help me,

I currently work on a project management hours of an agent, the fact I have a picture that I recovered with the expression = intervall (max (time), min (time) )

name	day	time in	time out	total
test1	monday	07:30	17:30	08:00
test1	Tuesday	07:30	17:40	08:10
test1	Wednesday	07:30	17:30	08:00
test1	Thursday	07:30	17:30	08:00
test1	Friday	07:30	17:30	08:00
test1	Saturday	10:30	14:30	04:00

the problem is that want to sum the results of the previous table depending on the week to another simple table that I wish writing.

I have thought about a loop.