Need a formula help:

[pedie]

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


Please help

 

[pedie]

It returned <TABLE style="WIDTH: 44pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=59 border=0><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 44pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" width=59 height=18>#NAME?</TD></TR></TBODY></TABLE>

 

[pedie]

When I click on cell it show in formula bar as "9/11/2010 8:01:27 PM" but without clicking on it, it looks like "<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>"

This is the result of date & " "& time from vba code I guess.

P.S. Joe, sure. And thanks for that.

 

[pedie]

<?XML:NAMESPACE PREFIX = TIMEVALUE("16 /><TIMEVALUE("16:00")),"Mor","Eve")< p><TIMEVALUE("16:00")),"Mor","Eve")< p><TIMEVALUE("16:00")),"Mor","Eve")< p>This is working if there is no date with the time but I need sol to work with the date
<TABLE style="WIDTH: 133pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=177 border=0><COLGROUP><COL style="WIDTH: 133pt; mso-width-source: userset; mso-width-alt: 6473" width=177><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 133pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: white" width=177 height=17>IF(AND(I4>TIMEVALUE("07:00"),I4<TIMEVALUE("16:00")),"Mor","Eve")</TD></TR></TBODY></TABLE>
</TIMEVALUE("16:00")),"Mor","Eve")<>
</TIMEVALUE("16:00")),"Mor","Eve")<>
</TIMEVALUE("16:00")),"Mor","Eve")<>

 

[pedie]

<?XML:NAMESPACE PREFIX = TIMEVALUE("16 /><TIMEVALUE("16:00")),"Mor","Eve")< p>B2 =IF(AND(I4>TIMEVALUE("07:00"),I4<TIMEVALUE("16:00")),"Mor","Eve") p <> Sorry for error earlier
</TIMEVALUE("16:00")),"Mor","Eve")<>
</TIMEVALUE("16:00")),"Mor","Eve")>

 

[shg]

Maybe =LOOKUP(MOD(A1, 1), --{0,"7:30","14:30"}, {"Eve","Morning","Eve"})

 

[meldoc]

Hi pedie

Try Peter's formula, from post #3 modified like this.

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

 

[pedie]

Special thanks to everyone, Peter, Brian, Shg....

Joe sorry again.


I needed to finish this today and small thing kept me stucked for a while now it is working because of you guys!


Thanks a million
Thank you so much!

Happy weekend guys!