;with yourTable (t) as 
(
       select convert(float, 10) union all
       select 10.25 union all
       select 10.5 union all
       select 10.75 union all
       select 11 union all
       select 11.11
)
select convert(int, floor(t)) as [Hour]
       ,convert(int, round(60 * (t - floor(t)),0))  as [Minute]
from yourTable

OUTPUT:
Hour        Minute
----------- -----------
10          0
10          15
10          30
10          45
11          0
11          7

quote:

---

Originally posted by MichelleMabbs

Hi there i have a series of times in decimal 15 min slots

the data type is float and the field is the followng:

10
10.25
10.5
10.75
11
and so on

i would like to convert that to the hour and 15 minute slot

10:00:00
10:15:00
10:30:00
10:45:00
11:00:00

Any idea how to do this would be really grateful

Michelle

---

SELECT CONVERT(time,DATEADD(n,(Field-FLOOR(Field))*60,DATEADD(hh,FLOOR(Field),0)))
FROM Table