Hi!

Use a format like [h]:mm:ss

Biff

"Mike" wrote in message
...
Thank you so much! Also, what do I need to do to show Hr:Min and seconds

"Biff" wrote:

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.