Count the Time in excel columns
Closed
sindhuG
Posts
1
Registration date
Wednesday November 3, 2010
Status
Member
Last seen
November 3, 2010
-
Nov 3, 2010 at 06:37 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 4, 2010 at 08:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 4, 2010 at 08:21 AM
Related:
- Count the Time in excel columns
- Popcorn time download - Download - Movies, series and TV
- How to change time in whatsapp - Guide
- Ocarina of time rom - Download - Action and adventure
- Number to words in excel - Guide
- How to count names in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 4, 2010 at 08:21 AM
Nov 4, 2010 at 08:21 AM
one way of doing this
suppose the data is like this from the second row.(that is from A2 B2)
in F1 enter 10/9/10
in G1 enter 10:00:00 PM
inH1 enter 10:59:59 PM
(this is only for writing the formula easily)
In an empty cell copy this formula
=SUMPRODUCT(((A2:A17+B2:B17)>=F1+G1)*((A2:A17+B2:B17)<=F1+H1))
you will get 4
suppose the data is like this from the second row.(that is from A2 B2)
in F1 enter 10/9/10
in G1 enter 10:00:00 PM
inH1 enter 10:59:59 PM
(this is only for writing the formula easily)
In an empty cell copy this formula
=SUMPRODUCT(((A2:A17+B2:B17)>=F1+G1)*((A2:A17+B2:B17)<=F1+H1))
you will get 4