How can i change Number to Hour format

[vengadeshpalani]

Hi All,

How can i change Number to Hour format

Data
9.0
9.5
10.0
10.5
11.0
11.5
12.0
12.5
13.0
13.5
14.0

[sunny_talwar · Accepted solution]

Just do this

Time(Data/24, 'h:mm') as Data

[marcus_sommer]

Try it with: time(1/24 * [Data]) as [Hour]

- Marcus