View original (French)

Excel hours in hundredths

Solved
jeanL Posted messages 3 Status Member -  
 marcel -
Hello,

I would like to know how to convert hours into hundredths in Excel: that is to say, for example:

that 8h30 in a cell = 8.50

With my thanks and best regards

JeanL

1 answer

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    hello

    To make a cell 8:30 display 8.50
    you just need to multiply it by 24 and set the format to number 2.

    always zen
    126
    1. jeanL Posted messages 3 Status Member 12
       
      Hello,

      Thank you "that works", in fact, I was making it more complicated, but when you don't know, it's great to rely on nice people -

      thanks again

      JeanL
      12
    2. babou
       
      Thank you very much gbinforme!!!
      4