Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Add times greater than and less than

16 views
Skip to first unread message

Jaime Calderon

unread,
Jan 24, 2024, 11:10:51 AMJan 24
to
Hi
I need help with a formula that counts howmany times we have greater than and less than.
The issue I'm running is The column contains DATETIME together
Here is an example
1/17/2024 12:29 PM
1/18/2024 8:57 AM
1/19/2024 10:13 AM
1/17/2024 12:34 PM
1/17/2024 10:48 AM
1/15/2024 16:08 PM
1/17/2024 14:47 PM
1/20/2024 10:42 AM


I need a formula that tells me howmany times are between 10:00 am -11:00 am (date does not matter) In this example it would be 3
0 new messages