Declare @WorkTimeInSeconds int Set @WorkTimeInSeconds = 144000 --This value is an example. Mostly values are above 86400 seconds Select ActualHoursWorked = convert(varchar,(@WorkTimeInSeconds)/3600) + ':' + right( '0' + convert(varchar,((@WorkTimeInSeconds) %3600)/60),2) + ':' + right( '0' + convert(varchar,(@WorkTimeInSeconds) %60),2)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)