How do i subtract 3 hrs from now()?

Seems fairly explicit to me. I could be wrong but I wouldn't bet against me!

--
Biff
Microsoft Excel MVP


"Bob Bridges" wrote in message
...
That'd be three hours ago. Assuming "three hours from now" means three
hours
in the future, use plus rather than minus; but the principle is correct.

--- "T. Valko" wrote:
=NOW()-0.125