By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 6 Duplicates: 0 Warnings: 0
dtestartdatetime | dteenddatetime |
---|---|
2024-02-27 08:30:00 | 2024-02-27 16:30:00 |
2024-03-11 08:30:00 | 2024-03-11 16:30:00 |
2024-03-12 08:30:00 | 2024-03-12 16:30:00 |
2024-03-13 08:30:00 | 2024-03-15 10:45:00 |
2023-11-13 11:05:00 | 2023-11-13 17:15:00 |
2024-01-31 14:15:00 | 2024-01-31 16:30:00 |
dtestartdatetime | dteenddatetime | dateDiff | loginTime_sec | logoutTime_sec | actualWorkingTime | officialWorkingTime | Working_Time_Lost |
---|---|---|---|---|---|---|---|
2024-02-27 08:30:00 | 2024-02-27 16:30:00 | 0 | 30600 | 59400 | 28800 | 28800 | 1.0000 |
2024-03-11 08:30:00 | 2024-03-11 16:30:00 | 0 | 30600 | 59400 | 28800 | 28800 | 1.0000 |
2024-03-12 08:30:00 | 2024-03-12 16:30:00 | 0 | 30600 | 59400 | 28800 | 28800 | 1.0000 |
2024-03-13 08:30:00 | 2024-03-15 10:45:00 | 2 | 30600 | 38700 | 8100 | 86400 | 0.0938 |
2023-11-13 11:05:00 | 2023-11-13 17:15:00 | 0 | 39900 | 62100 | 22200 | 28800 | 0.7708 |
2024-01-31 14:15:00 | 2024-01-31 16:30:00 | 0 | 51300 | 59400 | 8100 | 28800 | 0.2813 |
dtestartdatetime | dteenddatetime | Working_Time_Lost |
---|---|---|
2024-02-27 08:30:00 | 2024-02-27 16:30:00 | 1.0000 |
2024-03-11 08:30:00 | 2024-03-11 16:30:00 | 1.0000 |
2024-03-12 08:30:00 | 2024-03-12 16:30:00 | 1.0000 |
2024-03-13 08:30:00 | 2024-03-15 10:45:00 | 0.0938 |
2023-11-13 11:05:00 | 2023-11-13 17:15:00 | 0.7708 |
2024-01-31 14:15:00 | 2024-01-31 16:30:00 | 0.2813 |