Testing for time

[Lram]

I want to extract data based on time of occurrence each day. The date and time are in a column in the format 5/12/2007 0:00. How do I test for and extract associated data for say the period between 08:00 and 13:00 hours each day?

[Roger Govier]

Hi

To get the time from the cell, assuming date and time are in A1, enter in B1
=MOD(A1,1)
To test for time, in C1
=B1>(8,0,0)
in D1
=B1<time(13,0,0)

Obviously you can combine the 2 to get a overall True or False result
=AND(B1>time(8,0,0),B1<time(13.0.0))

[MarvinP]

I do an extract of data using Advanced Filters.
http://www.contextures.com/xladvfilter01.html