How do i subtract 3 hrs from now()?

  • Thread starter Thread starter Andy
  • Start date Start date
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.
 
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
 
How do i subtract 3 hrs from now()?

Seems fairly explicit to me. I could be wrong but I wouldn't bet against me!
 
He said 3 hours from Now(), the value returned by the Excel function, not 3
hours from now, this moment in time.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
More explicit

=Now()-"3:00"

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Yeah but with mine you can do

=NOW()-"3:00 PM"

<G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top