By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| WorkDate | StartTime | EndTime | StartLunch | EndLunch |
|---|---|---|---|---|
| 2020-09-01 | 07:30:00 | 18:00:00 | 13:00:00 | 15:00:00 |
| 2020-09-02 | 12:00:00 | 15:00:00 | 13:00:00 | 15:00:00 |
| 2020-09-03 | 15:00:00 | 18:00:00 | 13:00:00 | 15:00:00 |
| 2020-09-04 | 08:30:00 | 15:00:00 | 13:00:00 | 15:00:00 |
| WorkDate | Total_Work_Mins | Total_work_time |
|---|---|---|
| 2020-09-01 | 510 | 08:30:00 |
| 2020-09-02 | 60 | 01:00:00 |
| 2020-09-03 | 180 | 03:00:00 |
| 2020-09-04 | 270 | 04:30:00 |