Worker Punch-in, normal overtime execution-get overtime work

ALTER PROCEDURE [dbo]. [Hr_addnote3]
As
BEGIN
Update hr_1 Set Overtime remarks = ' normal overtime: ' + dbo. Gethour (Clock-in _e, clock-out _e) where

Clock-in _e < CONVERT (Datetime,convert (char (10), DateTime, +) + ' 18:31:00 ', 101) and
Clock-in _e > CONVERT (Datetime,convert (char (10), DateTime, +) + ' 18:00:00 ', 101) and
Clock-out _e > CONVERT (Datetime,convert (char (10), DateTime, +) + ' 19:00:00 ', 101) and
Clock out _e < CONVERT (Datetime,convert (char (10), DateTime, 120) + ' 22:40:00 ', 101)
and overtime note is null and time attendance number not in
(select attendance number from Hr where department in (' Research and Development ', ' software department ', ' Human resources ', ' financial center ', ' Sourcing center ', ' marketing ', ' engineering Department ', ' head office ', ' general manager ', ' Sales company '))
END

-----assembly Punch-In

Worker Punch-in, normal overtime execution-get overtime work