Hi Akash,

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.

please check your times. Here I have Afternoon Report from 12:00 until
17:59.
Do you have dates in the time cell?
If you can't get it to work please send an example workbook to
claus_busch(at)t-online.de


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