Convertir des heures en centièmes sur Google Sheets
Tati_9775
Posted messages
1
Status
Member
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor 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!
Related links:
- [Google Sheets] Show cell modification date
- [Google Sheets] Show cell modification date
- Sorting in Google Sheets with JavaScript macro across multiple columns
- Google Sheets: Format a row based on whether the date is past or not.
- Google Sheets: Conditional Formatting for Expired Dates.
- Google Sheets formatting during Google Forms increment.
2 answers
-
Hello,
To test:=((HOUR(E7)*100+(MINUTE(E7))/60*100))
Best regards. -
Hello,
=E7*24
works 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.
