select pocetak_rada,zavrsetak_rada,DATEDIFF(HOUR, pocetak_rada, zavrsetak_rada) AS [HOUR DatePart] from menetlevel where ID='1' result 2007-03-01 07:50:00.000 2007-03-01 19:15:00.000 12 I'm missing minutes here