I want to make a formula where : If the time now is between 6:00 am and 8:00 am then type the word "early" is it possible rephrase this in excel to achieve the result?

CodePudding user response：

Yes, you can use any one of the following, assuming Cell A1 has a Time Value

=IF(AND(A1>=TIME(6,0,0),A1<=TIME(8,0,0)),"Early","")

or

=IF(AND(A1>="06:00:00",A1<="08:00:00"),"Early","")