View original (French)

Time Conversion LibreOffice

Solved
José-Arthure Posted messages 628 Status Member -  
 rroo -
In Libre Office, how to convert decimal numbers to hours minutes seconds.

Thank you.

Configuration: Windows XP / Firefox 10.0

--
http://site-pierre.fr/

1 answer

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    To convert decimal hours into hours minutes seconds, simply divide by 24 and set the cell to the time format

    For example, in A1: 3.5
    In B1 enter the formula:
    =A1/24
    and set cell B1 to the Time format:
    Format / Cells... / Numbers tab / Time
    you get: 03:30:00
    --
    Best regards
    Patrice
    9
    1. alex
       
      Hello,

      In my spreadsheet, this formula converts 28.75 into 4:45, whereas I want it to convert it into 29:15.
      Is that possible?
      Thank you in advance.
      0
    2. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      @ Alex

      You need to use the cumulative time format:
      [HH]:MM
      (instead of HH:MM)

      Best regards
      Patrice
      0
    3. alex
       
      Thank you very much :)
      0
    4. rroo
       
      You're welcome, cc.
      0
    5. rroo
       
      lol
      0