Posted to microsoft.public.excel.programming

Chuck[_11_] Chuck[_11_] is offline

external usenet poster

Posts: 58

Subtract 5 minutes from Now()

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

Chuck

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtract 30 minutes from Formula	Karen	Excel Worksheet Functions	9	August 25th 08 11:26 PM
subtract minutes from time	holtonh179	Excel Discussion (Misc queries)	2	March 29th 06 01:00 AM
How do you subtract time? (ie 03:15 am minus 5 minutes)	Dennis	Excel Discussion (Misc queries)	2	May 11th 05 03:56 AM
Subtract one time from another and get answer in minutes	Zoombini	Excel Discussion (Misc queries)	3	April 22nd 05 12:56 AM
What formula is used to add or subtract minutes from a time in a .	Lucky Phil	Excel Worksheet Functions	1	April 17th 05 08:07 AM

All times are GMT +1. The time now is 07:25 AM.

About Us

"It's about Microsoft Excel"