Need a formula help:

[pedie]

if time is between 7:30 to 14:30 then "Morning","Eve"....


Please help

 

[pedie]

Re: Need a formula help: Urgent please!

Bump..sort of urgent

 

[VoG]

Try

=IF(AND(MOD(NOW(),1)>="07:30"+0,MOD(NOW(),1)<="14:30"+0),"Daytime","Evening")

 

[pedie]

Peter, thank and sorry. If A2 is where the time is and not the now thing.

If A2 time falls between 7:30 to 14:30 then "Morning","Eve"....

 

[VoG]

Try

=IF(AND(A2>="07:30"+0,A2<="14:30"+0),"Daytime","Evening")

 

[pedie]

A1 = <TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=80 border=0><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 60pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=80 height=18>8:01:27 AM</TD></TR></TBODY></TABLE>and that is why it is showing Eve though it should be Morning. Can we please change the formula...

Peter thank you but please help again

 

[Joe4]

Bump..sort of urgent

Please wait more than 6 minutes before bumping your posts!
(see item #23 here: http://www.mrexcel.com/forum/showthread.php?t=127080)

 

[pedie]

Joe, sorry. Was sort of desperate. I came up with so many formulas but did not work as expected....

My apologies.

 

[VoG]

Is that an Excel time or Text. What does =NUMBER(A2) return?

 

[Joe4]

Joe, sorry. Was sort of desperate. I came up with so many formulas but did not work as expected....:wink:

My apologies.

There is a good chance that bumping your threads so quickly will actually reduce the chance that people see your question, as that question no longer shows up on the list of threads with no replies (that is the first thing I, and many other usersm look at).

So it is generally recommended not to bump posts until they are at least hours old and have fallen back a few pages (in most cases, I would recommend waiting a full day, as there are people logging on all over the world at different times, and this would allow them all to see it as unanswered).