View original (French)

Countdown in Open Office Calc?

Solved
Tobibi Posted messages 18 Status Member -  
 FieldyLady -
Hello everyone,

Here, I would like to create a kind of countdown in my Calc file. Let me explain more clearly; I simply want a countdown to appear in a cell that I will choose, regarding the date of June 7, 2012, at 00:01.

Thus, I would like to see the number of days, hours, minutes, and seconds remaining before this given date.

Hoping to find a little help here (perhaps trivial) to finalize my file.
Thank you in advance

Configuration: Windows Vista / Safari 534.30

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello

    With this formula: 

    =CONCATENATE(INT(DATEVALUE("June 7, 2012")-NOW());" days ";TEXT((DATEVALUE("June 7, 2012")-NOW())-INT(DATEVALUE("June 7, 2012")-NOW());"h:m:s"))

    you get the days and hours, minutes, seconds before June 7, 2012
    As soon as you recalculate your workbook, it updates.

    edit: with Excel you can simplify it like this: 

    =INT("June 7, 2012"-NOW())&" days "&TEXT(("June 7, 2012"-NOW())-INT("June 7, 2012"-NOW());"h:m:s")


    Always zen
    3
    1. FieldyLady
       
      Hello,
      Thank you for your formula; it also helps me a lot.
      Do you have the possibility to tell me how I could modify it so that only the working days before July 27, 2019, appear? That is, 5 days a week (public holidays will not be taken into account, but that's okay! :)
      Thank you, thank you.
      0
  2. Tobibi Posted messages 18 Status Member
     
    Hello,

    Thank you very much gbinforme, it's working just as I wanted :)
    0