T
T. Valko
If anyone is still following this thread...
Problem solved!
The OP's data *already* was true Excel dates/times.
When this data was pasted into the forum and then copy/pasted into a test
file it was pasted as TEXT which lead those of us that replied to craft
formulas based on the data being text (which it was in *our* test files).
The working formula:
=SUMPRODUCT(--(MOD(range,1)>=x),--(MOD(range,1)<x))
Problem solved!
The OP's data *already* was true Excel dates/times.
When this data was pasted into the forum and then copy/pasted into a test
file it was pasted as TEXT which lead those of us that replied to craft
formulas based on the data being text (which it was in *our* test files).
The working formula:
=SUMPRODUCT(--(MOD(range,1)>=x),--(MOD(range,1)<x))