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
|