SELECT
employee_id,
check_in,
check_out,
TIMEDIFF(check_out, check_in) AS work_duration,
CASE
WHEN TIMEDIFF(check_out, check_in) > '08:00:00' THEN TIMEDIFF(check_out, check_in) - '08:00:00'
ELSE '00:00:00'
END AS overtime_duration
FROM
attendance_records
WHERE
date = '2024-01-15';
利唐i人事HR社区，发布者：HR_learner，转转请注明出处：https://www.ihr360.com/hrnews/20241224184.html
