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