Divide by 24 and format as time.
--
David Biddulph

"GEM" wrote in message
...
What function can I use to convert a decimal number to a time number?? For
example,

The decimal number "1.50" would mean 1 HOUR 30 MINUTES.

1.25 would mean 1 HOUR 15 MINUTES.

Is there a formula for this operation??