To build up a formula to display remaining hours, minutes, and seconds until deadline for a report. Deadline is always Wednesday 6:00 PM (can be changed later).
Regarding the deadline formula, the Number 4 represents Wednesday ... and can obviously be changed for another day of the week ...
Now regarding your ' remaining time to deadline ' formula ...
Let's assume in cell A2 you have = Now()
and in cell B2 you have the above formula for the Wednesday deadline ...
Then you could test the following formula :
=INT(B2-A2)&" days "&TEXT(B2-A2,"h"" hrs ""m"" mins ""s"" secs""")
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
|Insert time/date with click on cell but never update|
|How to create a time series frequency conversion|
|How to obtain True/False statement if times are within x minutes of each other|
|How to select time stamp ranges and assign the correct tour destination|
|How to format time format conversion from decimal numbers|