View original (French)

Excel heures en centième

Solved
jeanL Posted messages 3 Status Membre -  
 marcel -
Bonjour,

Je voudrais savoir comment convertir dans excel des heures en centième: c'est à dire par exemple:

que 8h30 soit 8:30 dans une cellule = 8,50

Avec mes remerciements salutations

JeanL

1 answer

Answer 1 / 1
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 742
 
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