dear friend,

sorry this is a duplicate post...

i posted this same forumn in

http://www.sqlservercentral.com/Forums/Topic484052-323-1.aspx

by mistake i posted two times...

sorry for that...........

any way i solved this problem using simple article...

dear all

thanks for ur help....

i done this caculation...

check this link........

http://www.sqlteam.com/article/working-with-time-spans-and-durations-in-sql-server