Double of Total Problem
- by Gopal
Table1
ID | WorkTime
-----------------
001 | 10:50:00
001 | 00:00:00
002 | ....
WorkTime Datatype is *varchar(.
SELECT ID,
CONVERT(varchar(10), TotalSeconds1 / 3600) + ':' + RIGHT('00' + CONVERT(varchar(2), (TotalSeconds1 - TotalSeconds1 / 3600 * 3600) / 60), 2) + ':' + RIGHT('00' + CONVERT(varchar(2), TotalSeconds1 -…