C
Chuck
If A1 = 5
How can I display a Date/Time [A1] minutes earlier than Now()
Chuck
How can I display a Date/Time [A1] minutes earlier than Now()
Chuck
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
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
Thanks guys.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/60Since 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
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.