CREATE TABLE JobTran
(JobNbr VARCHAR(10),
ClockIn DATETIME NOT NULL,
ClockOut DATETIME NULL);
INSERT INTO JobTran (JobNbr, ClockIn, ClockOut)
VALUES('Job1', '2013-10-03 06:17:34.387', NULL),
('Job1', '2013-10-03 05:17:34.387', '2013-10-03 08:10:34.387'),
('Job2', '2013-10-03 09:17:34.387', '2013-10-03 10:05:34.387'),
('Job2', '2013-10-03 09:17:34.387', NULL);
DECLARE @getdate-2 DATETIME = GETDATE();
/* For your Test */ SELECT @getdate-2 = '2013-10-03 11:15:34.387';
SELECT
JobNbr,
SUM(DATEDIFF(SECOND, ClockIn, ISNULL(ClockOut, @getdate-2)) / 60. / 60.) AS ClockTime
FROM
JobTran
GROUP BY
JobNbr;
