Hi Team,

Require a formula for the following situation:

CELL A1 contains a Time
CELL B1 contains a Writeup as Morning Report / Afternoon Report / Evening Report.

if Cell A1 is equal or between 12:00AM to 11:59 AM then CELL B1 should display Morning Report

if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report

if Cell A1 is equaly or between 18:00PM to 23:59 PM then CELL B1 should display Evening Report

Pls help how to cope up with this.

Pls guide.

Rgds

Akash Maheshwari