In article ,
"MHoffmeier" wrote:

Sorry, the OP had expired in my reader.

You can always find it in the archives...

http://groups.google.com/advanced_gr...=group:*excel*

How about
=IF(NOW()(ROUNDUP(NOW(),0)-1/24*7),ROUNDUP(NOW(),0)+1-1/24*7-NOW(),RO
UNDUP(NO W(),0)-1/24*7-NOW()) Seems to work

The salient thing to me about the original post seemed to be using the
words "hour(s)", "minute(s)", and "second(s)" conditionally, not just
getting the time remaining.