add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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