View original (French)

Time between two times

Solved
soubisien85 -  
Good evening everyone,

Help, I would like to know the time between two times in the format: dd/mm/yy/hh/mm
Let's say A1 is the current time and A2 is the time of my appointment, I want to know how much time I have left for my appointment, which is A2-A1

Thank you in advance

Best regards

Soubisien85

2 answers

  1.  Kaxim1
    In another cell, enter =A2-A1 and then press enter :)
    1. soubisien85
      If it were that simple! I'm talking about a date like 26/02/14 23:00, to know how much time until 01/03/2014 12:00 for example...
      So your A2-A1 seems weak to me... ;-))
    2. Kaxim1
      Ah ok, I didn't understand ...
      But how do you want the result??
    3. soubisien85
      Same format, which is dd/mm/yy hh/mm
      I am on Open Office Calc
    4. Kaxim1
      I see no other solution than: In A1 = Current time; A2 = Appointment time
      B1 = Current date; B2 = Appointment date
      Then in A3: =A2-A1 and in B3: =B2-B1,
      you will have your result with the number of remaining days and hours.
    5. soubisien85
      no, it's not like that
  2. eriiic Contributor
    Good evening,

    duplicate, everything was explained here by Vaucluse: https://forums.commentcamarche.net/forum/affich-29779003-heures-et-decimales

    Eric

    --
    In addition to thanking (yes, it’s done!!!), remember to mark it as solved when it’s the case (at the top near your title).
    Thank you
    1. soubisien85
      Primo: I thanked Vaucluse two paragraphs ago
      secundo: Vaucluse explained to me how to calculate the difference between two times, but not when there are also the days, that is to say in the format dd/mm/yy hh/mm

      no but... ;-)
    2. eriiic Contributor
      Hello,

      First: he explained it to you
      Second: you just need to read
      Third: when you're given the solution you respond no that's not how it is

      Eric
    3. soubisien85
      I don't think I need any lessons in manners from you; I was perfectly correct with Vaucluse, so mind your own business.
    4. eriiic Contributor
      I was completely correct with Vaucluse
      Did I say the opposite?
      I correct the second: you just need to know how to read
      eric
    5. SOUBISIEN85
      I’m not asking you for anything.... I found my answers, especially not thanks to you...