Hi Jaspreet,

Am Thu, 19 Apr 2012 05:00:36 +0000 schrieb Jaspreet281:

for instance i appliad it on 09.48am it still returned me Incorrect,
actually this should be correct, sceondly as i mentioned what ever time
i am taking the end result is incorrect only,

my target cell is in this format 11/5/2011 9:48:46 AM and its a 24hrs
format.

try:
=IF(OR(ROUND(MOD(A1,1),2)=22/24,ROUND(MOD(A1,1),2)<=7/24),"incorrect","correct")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2