Transform hundredths of an hour into hours and minutes
Ghislaine
-
contrariness Posted messages 17905 Registration date Status Member Last intervention -
contrariness Posted messages 17905 Registration date Status Member Last intervention -
Hello,
I searched thoroughly in the forum, but I couldn't find how to convert hours/centièmes to hours/minutes in an Excel table. My table is a monthly summary that details the overtime/regular hours ... of each person.
Here is my example:
B5: 37.33
B6: 38.73
These cells correspond to the number of hours worked during the week. I then calculate the overtime for the individuals. When I summarize for these individuals, I would like the input of 38.73 to be converted to 38h44m in my Excel table (I don't know if that's possible).
Thank you for your help. I am working with Excel 2002
Configuration: Windows XP / Internet Explorer 6.0
I searched thoroughly in the forum, but I couldn't find how to convert hours/centièmes to hours/minutes in an Excel table. My table is a monthly summary that details the overtime/regular hours ... of each person.
Here is my example:
B5: 37.33
B6: 38.73
These cells correspond to the number of hours worked during the week. I then calculate the overtime for the individuals. When I summarize for these individuals, I would like the input of 38.73 to be converted to 38h44m in my Excel table (I don't know if that's possible).
Thank you for your help. I am working with Excel 2002
Configuration: Windows XP / Internet Explorer 6.0
