Subtract 5 minutes from Now()

R

Ron Coderre

Try this:

=NOW()-5/(24*60)
Format the cell in an appropriate date/time format.

Just be aware that the cell won't keep incrementing at regular
intervals....Only when you recalculate.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
R

Ron Coderre

Actually, to match your request to use the value in Cell A1....

Try this:
=NOW()-A1/(24*60)

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Ron Coderre said:
Try this:

=NOW()-5/(24*60)
Format the cell in an appropriate date/time format.

Just be aware that the cell won't keep incrementing at regular
intervals....Only when you recalculate.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Chuck said:
If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()

Chuck
 
G

Guest

Since I always have a hard time remembering the "24*60" (not sure why), I
prefer to do this another way.

=NOW()-TIME(0,A1,0)

or you could try the following for a constant time period:

=NOW()-"00:05:00"

Thanks,
Mike


Ron Coderre said:
Actually, to match your request to use the value in Cell A1....

Try this:
=NOW()-A1/(24*60)

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Ron Coderre said:
Try this:

=NOW()-5/(24*60)
Format the cell in an appropriate date/time format.

Just be aware that the cell won't keep incrementing at regular
intervals....Only when you recalculate.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Chuck said:
If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()

Chuck
 
C

Chuck

On Tue, 18 Sep 2007 17:06:00 -0700, Michael Bowers <Michael
Since I always have a hard time remembering the "24*60" (not sure why), I
prefer to do this another way.

=NOW()-TIME(0,A1,0)

or you could try the following for a constant time period:

=NOW()-"00:05:00"

Thanks,
Mike


Ron Coderre said:
Actually, to match your request to use the value in Cell A1....

Try this:
=NOW()-A1/(24*60)

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Ron Coderre said:
Try this:

=NOW()-5/(24*60)
Format the cell in an appropriate date/time format.

Just be aware that the cell won't keep incrementing at regular
intervals....Only when you recalculate.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()

Chuck
Thanks guys.
I had tried: A1=5/24/60 then
now() - A1
It treated the value in A1 as a year so I tried (amoung many other things):
now() - [A1]minute
Macro wouldn't accept it.
So simple. Thanks again.

Chuck
 
C

Chuck

On Tue, 18 Sep 2007 17:06:00 -0700, Michael Bowers <Michael
Since I always have a hard time remembering the "24*60" (not sure why), I
prefer to do this another way.

=NOW()-TIME(0,A1,0)

or you could try the following for a constant time period:

=NOW()-"00:05:00"

Thanks,
Mike


Ron Coderre said:
Actually, to match your request to use the value in Cell A1....

Try this:
=NOW()-A1/(24*60)

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

Ron Coderre said:
Try this:

=NOW()-5/(24*60)
Format the cell in an appropriate date/time format.

Just be aware that the cell won't keep incrementing at regular
intervals....Only when you recalculate.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()

Chuck
Correction: Now() - [A1]/24/60
square brackets around A1

Thanks guys.
I had tried: A1=5/24/60 then
now() - A1
It treated the value in A1 as an DAY so I tried (amoung many other things):
now() - [A1]minute
Macro wouldn't accept it.
So simple. Thanks again.

Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top