=IF(OR(HOUR(M14)<7,HOUR(M14)>21),"Yes","No")
Rajan
On Wed, Mar 30, 2011 at 5:23 PM, wrote:
> Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column AColumn BColumn C
> DateTim
here is the formula
=IF(B2<=(7/24),"Yes",IF(B2>=(21/24),"Yes","No"))
On Wed, Mar 30, 2011 at 5:23 PM, wrote:
> Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column AColumn BColu
so... make it simplest
=IF((B2>=7/24)*(B2<=*21*/24),"NO","YES")
On Thu, Mar 31, 2011 at 12:23 AM, JsinSk wrote:
> On my response I screwed up the 24 hour time format! Should be 21:00
> instead of 17:00.
>
> On Mar 30, 1:17 pm, "STDEV(i)" wrote:
> > Try this formula
> >
> > *=IF((B2>=7/24)*(B2
On my response I screwed up the 24 hour time format! Should be 21:00
instead of 17:00.
On Mar 30, 1:17 pm, "STDEV(i)" wrote:
> Try this formula
>
> =IF((B2>=7/24)*(B2<=9/24),"NO","YES")
>
> On Wed, Mar 30, 2011 at 6:53 PM, wrote:
> > Hi All,
>
> > I need formula to update column C, value if the
Try this formula
=IF((B2>=7/24)*(B2<=9/24),"NO","YES")
On Wed, Mar 30, 2011 at 6:53 PM, wrote:
> Hi All,
>
> I need formula to update column C, value if the time is between 7:00 AM to
> 9:00 PM "YES" else "NO"
> Find attached for the same.
>
> Column AColumn BColumn C
> Date
