sir please implemenet on this query

select

[date],

min([Timein]) as First_Record,

sum(DATEDIFF(minute, [Timein], [Timeout])) as Time_Minutes

into #temp1 from Atend

where eid = 26446

group by [date]

GO

select

t.[date],

t.eid,

t.[Timein] as timein,

t.[Timeout] as timeout,

CONVERT(VARCHAR(8), DATEADD(minute, Time_Minutes, 0), 108) AS SpendTime,

case when (540 - Time_Minutes) > 0 Then '- ' else '+ ' end

+CONVERT(VARCHAR(8), DATEADD(minute, ABS(540 - Time_Minutes), 0), 108) as excesshorttime

FROM Atend t

left join #temp1 t2 on t.[date] = t2.[date] and t.[Timein] = t2.First_Record

where eid = 26446

order by t.[date], t.[Timein]

i want this type of data

date----------------------------eid----shift--------timein---------------------timeout--

2013-05-04 00:00:00.000--17031----G----2013-06-13 09:15:00.000-----2013-06-13 15:23:00.000

2013-05-04 00:00:00.000--17031----O-----------NULL------------------------NULL