View original (French)

Excel hours in hundredths

Solved
jeanL Posted messages 3 Status Membre -  
 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

Answer 1 / 1
gbinforme Posted messages 15481 Registration date   Status Contributor Last intervention   4 731
 
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
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
babou
 
Thank you very much gbinforme!!!
4