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 réponses

ccm81 Posted messages 11033 Status Membre 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