How do i subtract 3 hrs from now()?

[T. Valko]

=NOW()-0.125

 

[Bob Bridges]

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.

 

[Peo Sjoblom]

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

 

[T. Valko]

How do i subtract 3 hrs from now()?

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

 

[Bob Phillips]

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)

 

[Bob Phillips]

More explicit

=Now()-"3:00"

--
---
HTH

Bob


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

 

[David Biddulph]

.... or =NOW()-TIME(3,0,0)
--
David Biddulph

More explicit

=Now()-"3:00"

--
---
HTH

Bob


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

 

[Bob Phillips]

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)