Thread: Time countdown...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default 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 QuoteReply With Quote