Posted to microsoft.public.excel.programming

Rick

external usenet poster

Posts: 334

How to subtract 7 min from 08:55 AM

I have a problem that I cannot figure out.
How to subtract a fraction of time from a Start time:
A1=08:50 AM , A2 needs to test A1 for less than or greater than 7 minutes of
09:00 AM.

Thanks

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 Min() from MAX()	airgrz	Excel Discussion (Misc queries)	4	May 3rd 23 05:08 PM
How do i subtract 3 hrs from now()?	Andy	Excel Worksheet Functions	9	April 29th 23 11:44 AM
subtract	uindt	Excel Worksheet Functions	1	April 29th 08 05:05 AM
how to subtract one row from the other?	prasad	Excel Discussion (Misc queries)	1	April 8th 05 08:38 PM
Add IF or Subtract IF??	RJ	Excel Worksheet Functions	4	November 30th 04 09:03 PM

All times are GMT +1. The time now is 04:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us