Dear Myur,
=IF(AND(TEXT(B19,"hh:mm")>"07:00",TEXT(B19,"HH:mm")<"17:00"),"NO","YES")
You can use the above formula.
Dear Akash,
Pls attach the sample file.
So we can help you better.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
---
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 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 A Column B C
You can use this formula, make sure to change C6 to the cell your data
is located.
=IF(AND(C6>TIMEVALUE("07:00"),C6 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 A Column B C
