View original (French)

90 minutes

Solved
christophedir Posted messages 201 Status Member -  
christophedir Posted messages 201 Status Member -
Hello
I took a good look, but I can't find what I'm looking for

In A1 I have a production time in hh:mm (01h30)

In A2 I would like the sum of hours and minutes, which is 90

Best regards

christophedir

3 answers

  1. Anonymous user
     
    Hello,
    Try A2=(HOUR(A1)*60)+MINUTE(A1), it works in LibreOffice.
    --
    I don't know any more than you do, but I'm looking.
    1
  2. christophedir Posted messages 201 Status Member
     
    Hello old-painful

    The formula works

    Thank you

    Best regards

    CHristophedir
    0
  3. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello to both of you

    You have a bit simpler
    =A1*1440

    Best regards
    0
    1. christophedir Posted messages 201 Status Member
       
      Hello

      I just saw your message, and your solution works great

      Thank you
      0