count down timer

N

NED

is there a way of adding a count Clock to a cell which will take my
current time from my system clock to a date of my choice ie. time now 1.00pm
11/12/07 to 00:00:00 01/01/08
 
J

Jim May

Not sure, but I entered =DATEVALUE("12/25/2007")-NOW()
and formatted cell as Time 37:30:20
and got 328:36:02 (Hours. minutes & seconds) till Christmas
Day;;;;
 
B

Bob Phillips

You have responses in your earlier thread. Don't double-post!

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top