hi

Well my senior developer tell me that just calculate spend time and excess short and show it into report.for right now he didnt tell me to insert it.

Thank you for your help your query is working fine

and thanks for explaining me.

please can u tell me one thing

this is my spendtime query

SELECT CalDate,[Timein],[Timeout],

CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108) AS SpendTime

FROM attendance

how...

i have this type of table

CREATE TABLE attendance

(

Date datetime,

...