By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ClockedIn | ClockedOut | H | M |
|---|---|---|---|
| 2016-01-01 09:30:00.000 | 2016-01-01 18:30:00.000 | 9 | 0 |
| 2016-02-01 08:10:00.000 | 2016-02-01 18:20:00.000 | 10 | 10 |
| ClockedIn | ClockedOut | Hours (H:MM) |
|---|---|---|
| 2016-01-01 09:30:00.000 | 2016-01-01 18:30:00.000 | 9:00 |
| 2016-02-01 08:10:00.000 | 2016-02-01 18:20:00.000 | 10:10 |