select 
sum(trunc((r.Exit-r.Enter)*24))Hour,MOD(sum(trunc((r.Exit-r.Enter)*24*60)),60)Min,
e.PERSON_NUMBER,e.CODE_DEPARTMENT,e.SURNAME_ENPLOYER,e.NAME_ORGANIZATION,e.NAME_DEPARTMENT,e.POST,e.NUMBER_DEPARTMENT,e.NAME_EMPLOYER,e.PATRANOMIC_EMPLOYER
from registration r left join EMPLOYESS e on r.hid_emp=e.hid 
where PERSON_NUMBER like '%%' and CODE_DEPARTMENT like '%%' and SURNAME_ENPLOYER like '%???%' 
and NAME_ORGANIZATION like '%%' and NAME_DEPARTMENT like '%%' and POST like '%%' 
and NUMBER_DEPARTMENT like '%%' and NAME_EMPLOYER like '%%' and PATRANOMIC_EMPLOYER like '%%' and ID_CARD like '%%' 

select 
sum(trunc((r.Exit-r.Enter)*24))Hour,MOD(sum(trunc((r.Exit-r.Enter)*24*60)),60)Min,
e.PERSON_NUMBER,e.CODE_DEPARTMENT,e.SURNAME_ENPLOYER,e.NAME_ORGANIZATION,e.NAME_DEPARTMENT,e.POST,e.NUMBER_DEPARTMENT,e.NAME_EMPLOYER,e.PATRANOMIC_EMPLOYER
from registration r left join EMPLOYESS e on r.hid_emp=e.hid 
where PERSON_NUMBER like '%%' and CODE_DEPARTMENT like '%%' and SURNAME_ENPLOYER like '%???%' 
and NAME_ORGANIZATION like '%%' and NAME_DEPARTMENT like '%%' and POST like '%%' 
and NUMBER_DEPARTMENT like '%%' and NAME_EMPLOYER like '%%' and PATRANOMIC_EMPLOYER like '%%' and ID_CARD like '%%'  group by e.PERSON_NUMBER