View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do i subtract 3 hrs from now()?

I believe Biff's assumption is correct, why would someone use subtract if
they mean in the future,
I mean if the OP would have said subtract 3 hours from 15:00 it becomes even
more clear.
OTOH if someone says 3 hours from now it means 3 hours into the future. In
this case
I would go with Biff's assumption.


--


Regards,


Peo Sjoblom



"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