Posted to microsoft.public.excel.worksheet.functions

Glenn

external usenet poster

Posts: 1,240

Time countdown...

Gary''s Student wrote:
This is because NOW() returns BOTH the date and the time. Therefore =B1-NOW()
is negative. Try:

=B1-(NOW()-TODAY())
and adjust the format

Or:

=B1-MOD(NOW(),1)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
countdown to date and time	michelle	Excel Discussion (Misc queries)	7	October 3rd 07 02:37 PM
Countdown	simserob	Excel Worksheet Functions	0	July 21st 06 06:27 PM
Countdown	simserob	Excel Worksheet Functions	0	July 21st 06 06:26 PM
Day/Time Countdown	SeekingHelp	Excel Discussion (Misc queries)	6	September 28th 05 03:03 AM
real-time countdown	scottmiller	Excel Worksheet Functions	2	September 27th 05 11:30 PM

All times are GMT +1. The time now is 12:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us