Convert hours to hundredths in Excel
Solved
brimon33
-
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
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