scaggiano70
New Member
- Joined
- May 28, 2015
- Messages
- 1
Hello. My Excel skills are a bit rusty. Could someone help me figure out how I can pull the data I'm looking for (from AA3) based on the condition that O3 must be between 5 am and 10 pm?
N3 = 5/27/15
CE - 5/27/15
O3 = 8:48:00 AM
AA3 = 273
Here's what I have and of course it's not working!
=IF($N3=(CE$1),O3>TIMEVALUE("05:00"), O3<TIMEVALUE("10:00"), AA3," ")
The answer I'm trying to get is 273. This should be true because 8:48 am falls between 5:00 am and 10:00 pm.
Any help would be greatly appreciated!!
N3 = 5/27/15
CE - 5/27/15
O3 = 8:48:00 AM
AA3 = 273
Here's what I have and of course it's not working!
=IF($N3=(CE$1),O3>TIMEVALUE("05:00"), O3<TIMEVALUE("10:00"), AA3," ")
The answer I'm trying to get is 273. This should be true because 8:48 am falls between 5:00 am and 10:00 pm.
Any help would be greatly appreciated!!