Hi,

Am Thu, 26 Nov 2015 10:10:43 -0800 (PST) schrieb Akash Maheshwari:

Although Its working fine but Afternoon Status is only between 12:00hr till 13:00hrs. As soon as it crosses 13:00 hrs the status changed to Evening Report.

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


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