Screening through days of the week including time

R

rhhince

I have a whole column of dates and time. I am trying to screen out
Fridays and 20:00 to prevent trading at that hour. I have formulas
that trade every 20:00 during the week including Friday at that time.
I simply can't get the formula to screen it out. Any help would be
appreciated. Thanks.

Fri 1/20/2012 19:00 0.9342 0.9349 0.9339 0.9347 1088 44.24 40.84
41.56 0
Fri 1/20/2012 20:00 0.9348 0.9356 0.9345 0.9352 1147 47.25 42.44
41.28
Fri 1/20/2012 21:00 0.9353 0.9353 0.9340 0.9341 722 45.73 44.12
41.90 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suming Up Time over the course of days 1
How to sum up the value in column based on a 5 day week period? 1
Help - return date-time from a given # of days 1
Group by Day of the Week and Time Report 1
Access To Text For Webpage 1
Outlook connector crashes outlook 0
Outlook crashes with Outlook connector 2002 0
Excel Crashes all the time without reason 5

Top