Rather than using 6.30 to represent 6 hours and 30 minutes, and risk
confusion, better to use 6:30, which you can get merely by =A1/24 and format
as h:mm (or as [h]:mm if it might be beyond 24 hours).
--
David Biddulph
"Help on Excel sheet formula" <Help on Excel sheet
wrote in message
...
I want to convert number to hour like this.
Num Hour
1.00 1.00
6.50 6.30
0.25 0.15
3.75 3.45
Anyone has any idea, what sort of formula i have to put on excel sheet.