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.