View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default Timing Conversion problem

With the number in A1, =INT(A1)+(A1-INT(A1))*0.6 will do the conversion.
Just format in the comma style to get the two decimal points that represent
the minutes.

"Help on Excel sheet formula" wrote:

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.