Hi Bob, I compared the result using your formula with the one provided by
"Sloth" and it appears that I am off by a day using yours. 'Not sure why.


"Bob Phillips" wrote:

How about

=INT(A21-NOW())&" days, "&TEXT(MOD(A21-NOW(),1)," hh:mm:ss")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"marie" wrote in message
...
Hello experts,
What formula should I use to show # days left, including time (in hrs,
mins and sec's) from current date/time to a target end date/time?
For instance:

Start Date: Now()
End Date: December 31, 2005 5:00:00 PM

Your help is greatly appreciated.
Marie