ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   count down timer (https://www.excelbanter.com/excel-discussion-misc-queries/169219-count-down-timer.html)

NED

count down timer
 
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


Jim May

count down timer
 
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;;;;

"NED" wrote:

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


David Biddulph[_2_]

count down timer
 
See your earlier message.
--
David Biddulph

"NED" wrote in message
...
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




Bob Phillips

count down timer
 
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)



"NED" wrote in message
...
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





All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com