Hi!

Divide by 24 and format the cell as [h]:mm

=A1/24 = 17:30

Biff

"Mike" wrote in message
...
I have a program that gives me time in whole number format. ie 17.5 hours.
I
need to know how to I create a formula that would turn that in actual
hours
and minutes.