A running clock

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet which has a count down clock running which is imputed
from a site. The formula is set so that something happens 20seconds before 0.
$E$10<=TIMEVALUE("00:00:20")

The clock continues running past 0 and becomes a minus time. This upsets my
data somewhat. How can I make the clock not say a minus sign before the time.
 
I have a spreadsheet which has a count down clock running which is imputed
from a site. The formula is set so that something happens 20seconds before 0.
$E$10<=TIMEVALUE("00:00:20")

The clock continues running past 0 and becomes a minus time. This upsets my
data somewhat. How can I make the clock not say a minus sign before the time.
Click to expand...

change the formula to be =max(0,YourFormula)

This would make a negative number impossible
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time diffrence with 24 hour clock 3
Can't stop a clock 1
Count if formula error 5
Can't Stop the clock 2
how do i calculate hours worked in excel? 9
Can I use the NOW() function in a formula? 2
How to Subtract times on 24hour clock and avoid error message in . 5
Leaker claims Intel launching powerful 'Core i9 Skylake X' processors in June 0

Back
Top