View original (French)

Convert hours to hundredths in Excel

Solved
brimon33 -  
 brimon33 -
Hello,

I am a beginner in Excel.

Let’s take an example:
A1: 7:30 A2: 9:50 which equals 2:20.

How can I ensure that the result of 1:20 is systematically converted into a decimal? And that it translates to 2.33?

Please be explicit, as I will have a bit of trouble understanding.
Thank you very much for your help.
Best regards

Configuration: Windows / Internet Explorer 11.0

3 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    Your time in A2 in the format 1:20
    Formula in B2 (formatted as a number with 2 decimal places)
    =A2*24

    Best regards
    5