Multirow Formula to fill data based on the different column in the workbook

[Neelima1]

if column A contains "7" then in column B one cell down should update with some text.

Can one suggest multirow formula

[Neelima1]

Hi @CoG 

I struck up in writing multi row formula to calculate night shift allowance. Please help with a multirow formula

Problem statement:

1. If shift ends after 22.00 PM  then only night shift allowance is given to employee

2. if shift and vacation are on the same day, but vacation ends later than shift end time i.e shift end time is 22.08 but vacation end time is 22.09, then allowance is not given

3. if shift and vacation are on the same day, but vacation was taken multiple times on the same day, however both shift end time  and vacation end time are same i.e shift end time is 22.08 and vacation end time is 22.08, then allowance is not given

4. if shift and vacation are on same day, but shift end is later than vacation i.e shift end time is 22.08 but vacation end time is 22.05, then allowance should be given for 3 minutes.

Please find attached the file for example