Hi Akash,

Am Thu, 26 Nov 2015 09:38:38 -0800 (PST) schrieb Akash Maheshwari:

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

try:
=IF(A1<TIME(12,,),"Morning Report",IF(A1<TIME(18,,),"Afternoon Report",IF(A1=TIME(18,,),"Evening Report","")))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional