How do i subtract 3 hrs from now()?
 

Answer: How do i subtract 3 hrs from now()?
 

Sure, I can help you with that!

To subtract 3 hours from the current time in Excel, you can use the NOW() function to get the current date and time, and then subtract 3 hours from it using the TIME() function.

Here are the steps:

1. In a cell, type =NOW() to get the current date and time.
   
2. To subtract 3 hours from the current time, you can use the following formula: =NOW() - TIME(3,0,0)
   
   The TIME() function takes three arguments: hours, minutes, and seconds. In this case, we want to subtract 3 hours, so we use 3 for the hours argument, and 0 for the minutes and seconds arguments.
   
3. Press Enter to get the result.
   
   The cell should now display the current date and time minus 3 hours.
   

That's it! I hope this helps.

How do i subtract 3 hrs from now()?
 

=NOW()-0.125

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...

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

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

How do i subtract 3 hrs from now()?
 

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

How do i subtract 3 hrs from now()?
 

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 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

How do i subtract 3 hrs from now()?
 

More explicit

=Now()-"3:00"

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
=NOW()-0.125

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...

How do i subtract 3 hrs from now()?
 

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

"Bob Phillips" wrote in message
...
More explicit

=Now()-"3:00"

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
=NOW()-0.125

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...

How do i subtract 3 hrs from now()?
 

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)



"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
... or =NOW()-TIME(3,0,0)
--
David Biddulph

"Bob Phillips" wrote in message
...
More explicit

=Now()-"3:00"

--
---
HTH

Bob


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



"T. Valko" wrote in message
...
=NOW()-0.125

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...