View original (French)

Conversion des heures centièmes en heures et minutes

Solved
lilye44 Posted messages 2 Status Membre -  
lilye44 Posted messages 2 Status Membre -
Hello,

Hello,

I have data expressed in centihours in the form of 1.03 or 3.88 for example, which correspond to centihours. I need to convert them into hours and minutes regardless of the final format (1:03 or 1.03).
Is there a simple way?

Thank you

Configuration: Windows 7 / Internet Explorer 9.0

2 réponses

Réponse 1 / 2
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717
 
Hello,

ex:

A1: 1.03 B1: =A1/24 and format [h]:mm:ss gives 1:01:48

A1: 3.88 B1: =A1/24 and format [h]:mm:ss gives 3:52:48
11