24 hour countdown function

[superboy]

24 hour Countdown function


I have a countdown in my work sheet that counts 30 days from today if Cell A11 has a value and the date is in B11. Below is the function.
=IF(A11<>"",B11+30-TODAY(),"")

I love the function above because it counts in reference to a value. I would like something like this function but I want it to countdown 24 hours and not 30 days from today.

Thank you for your time in reading this.

 

[ExcelTactics]

24 hours in Excel's Time/Date format is just 1 day. Replace the 30 in your formula with 1 and you'll have the result. You'll want to see the output in hours, though, which means you may need to change the formatting on the cell this formula is in. One of these fine formats should do:

 

[superboy]

It doesn't work. It's a day counter, which means the values don't countdown(I.E the hours stay at 24:00:00 and after a day it resets to 00.00.00)
I am looking for a countdown that counts down 24 hours from any time of day. I want to be able to enter a value in A11 at say 2:00am and have the countdown initiated for 24 hours. Please help, any information would be helpful.

 

[ExcelTactics]

Oh, I forgot to mention - you're going to need to use NOW() - not TODAY(). NOW gives the time *and* day. TODAY just gives the day.

 

[superboy]

That's awesome, it works better with now. But is there anyway I can have it count down from the time I entered a value into Cell A11 instead of counting from the beginning of the day.

Oh, I forgot to mention - you're going to need to use NOW() - not TODAY(). NOW gives the time *and* day. TODAY just gives the day.

 

[ExcelTactics]

I'm not completely clear what you're trying for. If you want to count down the time between NOW and a date in the future, it would look like this:

Excel 2010

	A	B	C	D
Value	Future Time	Countdown	Now
Data

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]10[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]9/20/13 2:45 PM[/TD]
[TD="align: right"]14:18:40[/TD]
[TD="align: right"]9/20/13 12:26 AM[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C11[/TH]
[TD="align: left"]=IF(A11<>"",B11-NOW(),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]