By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
adrID | wrk_Start | wrk_End | wrk_Pause |
---|---|---|---|
10 | 2020-01-04 10:00:00.000 | 2020-01-04 18:00:00.000 | 00:00:00 |
10 | 2020-03-04 10:00:00.000 | 2020-03-04 17:30:00.000 | 00:30:00 |
10 | 2020-06-04 12:00:00.000 | 2020-06-04 14:00:00.000 | 00:00:00 |
10 | 2020-12-04 09:00:00.000 | 2020-12-04 16:50:00.000 | 00:30:00 |
adrid | decimal_hours |
---|---|
10 | 24.3333333 |