View original (French)

Conversion d'heure (6h30 pour 6:30) en heures (6h50)

toitoine -  
ALS35 Posted messages 1034 Registration date   Status Member Last intervention   -
Hello,
In column A, there are times noted in the form 6.30 for 6 hours and 30 minutes
column A is in number format.
How to convert with a formula 6.30 to 6.50?

Configuration: Windows / Chrome 77.0.3865.90

1 answer

  1.
    ALS35 Posted messages 1034 Registration date   Status Member Last intervention   147
     
    Hello,

    If your number is in A1 try
    =INT(A1)+MOD(A1,1)/6*10

    Best regards
    4