Dear Mr. Claus B.

Sorry to say but I would like to inform that its Not Working.

Rgds

Akash Maheshwari


On Thursday, November 26, 2015 at 11:53:01 PM UTC+5:30, Claus Busch wrote:
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