case when CONVERT(varchar(6),DATEDIFF(second,010_05, 010_06)/3600) + ':' + RIGHT('0' + CONVERT(varchar(2), (DATEDIFF(second, 010_05, 010_06) % 3600) / 60), 2) + ':' + RIGHT('0' + CONVERT(varchar(2), DATEDIFF(second,010_05, 010_06) % 60), 2) >'8:30:00' then convert(char(5),cast(IN010_06 - dateadd(hour,8,DATEADD(MINUTE,30,010_05)) as time), 108) else '00:00' end as overtime
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)