View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Quiller38 Quiller38 is offline
external usenet poster
 
Posts: 9
Default How to subtract 7 min from 08:55 AM

Rick,

If I understand you correctly, you need this in cell A2:

= If(((9/24)-A1)<(7/1440),"Less than 7 minutes","Not less than 7
minutes")


"Rick" wrote:

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