View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Timing Conversion problem

Try this:

=INT(A1)+MOD(A1,1)*60/100

Format as NUMBER 2 decimal places

Biff

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