Decimal value to time value

[PG2015]

As easy as it sounds I don't seem to be able to get this right.

Looking for a query that will take a value say 4.5 and convert to datevalue in hours so will end up as 04:30:00

Any help appreciated.

Thanks
:banghead:

 

[stopher]

myTime: TimeSerial(Int([myValue]),([myValue]-Int([myValue]))*60,0)

 

[PG2015]

Look at that - spot on!

Thanks very much

 

[apr pillai]

? format(4.5/24,"hh:nn:ss")
Result: 04:30:00

 

[PG2015]

Thanks very much - can use that too.

Thanks again