Como converter horário em FLOAT e retornar para horário no SQL SERVER
Exemplo realizado no Excel
Declare @data As time = '10:00:00.0000000'
,@H As Float
,@M As Float
,@S As Bigint
,@Result As Float
Set @H = Datepart(hh,@data)*3600
Set @M = Datepart(mi,@data)*60
Set @s = Datepart(ss,@data)
Set @Result = (@H + @M + @s) / 86400
Select CONVERT(TIME,cast(@Result as DateTime)) TIME, @Result FLOAT
