Sorry, the OP had expired in my reader.
How about
=IF(NOW()(ROUNDUP(NOW(),0)-1/24*7),ROUNDUP(NOW(),0)+1-1/24*7-NOW(),ROUNDUP(NOW(),0)-1/24*7-NOW())
Seems to work
"JE McGimpsey" wrote in message
...
That works for times between midnight and 17:00, but gives negative
times between 17:00:01 and 23:59:59, which will display as #######
unless the 1904 date system is used.
That may be acceptable for the OP (his goes negative after 17:00 too), I
don't know, but since his formula included words rather than just ":"s,
I assume not.
In article ,
"MHoffmeier" wrote:
=ROUNDUP(NOW(),0)-1/24*7-NOW()
|