SOLVED

Convertion d'heure

Copper Contributor

Bonjour à tous,

 

Je cherche à convertir une cellule où j'ai un nombre en heures et centièmes d'heure (67.86 heures pour être précis) en heures et minutes pour le résultat suivant: 67'40"

 

Merci pour votre aide 

2 Replies
best response confirmed by Philaos-49 (Copper Contributor)
Solution

@Philaos-49 First, divide your number by 24 to convert it into a number that can then be custom formatted as using the time format you desire. In your case that will be [hh]'mm'' as shown in the picture below.

 

Screenshot 2020-04-03 at 08.49.41.png

Merci, @Riny_van_Eekelen 

1 best response

Accepted Solutions
best response confirmed by Philaos-49 (Copper Contributor)
Solution

@Philaos-49 First, divide your number by 24 to convert it into a number that can then be custom formatted as using the time format you desire. In your case that will be [hh]'mm'' as shown in the picture below.

 

Screenshot 2020-04-03 at 08.49.41.png

View solution in original post