Convert a number to a time
Divide by 24 and format the resultant cell as [h]:mm
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Jack" wrote in message
...
I have the following number 232.5 which is 232 hours and 0.5 of an hour. I
want to convert this to 232 hours and 30 minutes or 232:30. How can i do
this? I know i need to multiply the decimal by 60, but how can i perform a
calculation on just the decimal part of a number and not the whole number?
|