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()