View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bridges Bob Bridges is offline
external usenet poster
 
Posts: 108
Default How do i subtract 3 hrs from now()?

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