Countdown in Open Office Calc?
Solved
Tobibi
Posted messages
18
Status
Membre
-
FieldyLady -
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
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 réponses
Hello
With this formula:
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:
Always zen
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
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.