To convert value in seconds or decimal value to hr:min:sec

Hi There,

I got 2 keyfigures which have the same data in decimal and seconds format like 1492.000 or 1492. In the <b>query</b> I want to convert this to HR:MIN:SEC format.

Can anybody help me to convert to hr:min:sec format. what is the formula that can convert this?

Thanks alot

Anima