Returning a Number when a time criteria is meet

[wdhayes]

I would really appreciate some help please

I am completing a roster and when a break is taken between 830am and 845am I would like to return 0.25 in a corresponding cell, if the time falls outside of this period I would like the formula to return 0

Where 830 is C10 and 845 is D10

 

[Aladin Akyurek]

Is this what you are after?

=IF(AND(C10="08:30"+0,D10="08:45"+0),0.25,0)

 

[wdhayes]

Is this what you are after?

=IF(AND(C10="08:30"+0,D10="08:45"+0),0.25,0)

Thanks Aladin Akyurek but the formula is returning 0

 

[seekerarcane]

In E10, write the followings;


=IF(AND(C10="08:30"+0,D10="08:45"+0),0.25,0)


Its working perfectly as per your requirement as described in your problem statement.

 

[Aladin Akyurek]

Thanks Aladin Akyurek but the formula is returning 0

What do you have in C10 and in D10 when you get 0?