View original (French)

Time between two times

Solved
soubisien85 Posted messages 264 Status Member -  
 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 Posted messages 70 Status Member 24
     
    In another cell, enter =A2-A1 and then press enter :)
    0
    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... ;-))
      0
    2. Kaxim1 Posted messages 70 Status Member 24
       
      Ah ok, I didn't understand ...
      But how do you want the result??
      0
    3. soubisien85
       
      Same format, which is dd/mm/yy hh/mm
      I am on Open Office Calc
      0
    4. Kaxim1 Posted messages 70 Status Member 24
       
      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.
      0
    5. soubisien85
       
      no, it's not like that
      0
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    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
    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... ;-)
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      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
      0
    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.
      0
    4. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      I was completely correct with Vaucluse
      Did I say the opposite?
      I correct the second: you just need to know how to read
      eric
      0
    5. SOUBISIEN85
       
      I’m not asking you for anything.... I found my answers, especially not thanks to you...
      0