Convertir des heures en centièmes sur Google Sheets
Tati_9775
Posted messages
1
Status
Membre
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello, I’ve consulted several exchanges to convert hours into hundredths from Google Sheets, but none have helped me to convert hours into hundredths.
Last year, I was using the formula =(HOUR(E7)*60-(+MINUTE(E7))/60 and it worked very well. I also tried *24 with no success. I remember having used another formula at that time. Who remembers? Or willingly a solution that works. Thank you in advance!
Last year, I was using the formula =(HOUR(E7)*60-(+MINUTE(E7))/60 and it worked very well. I also tried *24 with no success. I remember having used another formula at that time. Who remembers? Or willingly a solution that works. Thank you in advance!
2 réponses
Hello,
It must be ensured that E7 is in the correct time format h:mm (aligned to the right, otherwise it's text!), and the cell of your formula must be in Standard format.
Without the file, it's impossible to know your error...
eric
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you.
=E7*24works very well.
It must be ensured that E7 is in the correct time format h:mm (aligned to the right, otherwise it's text!), and the cell of your formula must be in Standard format.
Without the file, it's impossible to know your error...
eric
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you.