I have 3 value in in time like 10.98 , 10.97, 11.0 hour. I wrote aquery as

```
select d.EmployeeID, 
      ( (sum (floor(d.OTHour))+ floor(((sum(d.OTHour-floor(d.OTHour)))*100)/60))
        + cast(((cast(((sum(d.OTHour-floor(d.OTHour)))*100)as int))%60) as float)/100
      ) As TotalOT  
from DailyAttnProcess d 
where d.ShiftID in ( select distinct shiftID 
                            from ShiftTerm st, ShiftTermDetail std, Term t 
                            where st.ShiftTermID=std.ShiftTermID 
                                  and std.TermID=t.TermID and t.TermID=1) 
and d.AttnDate between '01 Oct 2016' and '31 Oct 2016' 
AND d.EmployeeID=9072  
Group By  d.EmployeeID

```

The result i get is 34.15 but the actual result should 32.57 . any one please help me by correcting this . Thanks in Advance.