View original (French)

Conversion des heures centièmes en heures et minutes

Solved/Closed
lilye44 Posted messages 2 Status Member -  
lilye44 Posted messages 2 Status Member -
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 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member 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