View original (French)

Convert decimal number to h/mn in Excel

Solved
isa -  
 hanaa -
Hello,
can you tell me how to convert 1.25 (which is 1 hour and 15 minutes) into the result: 1 h 15 mn
thank you
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1.
    LePierre Posted messages 249 Status Member 338
     
    Hello

    you just need to divide your value by 24 (=24 h) and set the format of your cell (C3 in the example) to time (hh:mm)
    example:
    if in B3 you have: 1.25
    paste in C3: 
    =B3/24
    --> 01:15

    see you later
    84
    1. Blabla
       
      Half an hour I've been looking for the answer in Excel's help. Thank you LePierre for this information.
      9
    2. Anonyme > Blabla
       
      Hello,
      I need to convert 4.9 hours into hours and minutes and I don't know how to do it. Please help me.
      1