If you divide 17.5 by 24, you will get a time equal 17:30.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"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.