(Convert (int, (SUM (hours ) + ( SUM (minutes ) / 60 ) + ( SUM (minutes ) % 60/ 60))))) +'.'+ (Convert (varchar (20), ( SUM (minutes ) % 60 ) % 60))) From time
hrs=5 mins=7 Then the output is 5.7 But the output should come 5.07
SELECT CAST( @Minute1/60 AS VARCHAR(5))+ ' HH' + '.'+ RIGHT('0' + CAST( @Minute1%60 AS VARCHAR(2)), 2)+' MM' AS 'WorkingTime'
Declare @Minute Int = 560 SELECT CAST( @Minute/60 AS Varchar(20))+ ' HH' + '.'+ RIGHT('0' + CAST( @Minute%60 AS VARCHAR(20)), 2)+' MM' AS 'WorkingTime'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)