Related:
- Counting cell with specific time
- Popcorn time download - Download - Movies, series and TV
- How to find specific words on a page - Guide
- Facebook id verification time - Guide
- How do i find a specific video on youtube - Guide
- Ocarina of time rom - Download - Action and adventure
3 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 13, 2009 at 03:16 AM
Apr 13, 2009 at 03:16 AM
Suppose data is in Column A and for selection purpose, Write 08:00 AM in Cell B2
B2=08:00 am
=COUNTIF(A:A,B2)
Else
=Countif(A:A,=COUNTIF(A:A,0.333333333333333)
.3333333333333 is the numeric value of 08:00 AM but making a cell as criteria is good approach ...
B2=08:00 am
=COUNTIF(A:A,B2)
Else
=Countif(A:A,=COUNTIF(A:A,0.333333333333333)
.3333333333333 is the numeric value of 08:00 AM but making a cell as criteria is good approach ...
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 22, 2009 at 01:44 AM
Apr 22, 2009 at 01:44 AM
Its working nicely with me...... change the cell format of Resulting Cell from Format > Cell > General> Number
Apr 15, 2009 at 08:33 PM
Should equal 22
=COUNTIF(B678:B708,E2)
E2= 08:00
00:00
08:00
08:00
08:00
08:00
00:00
00:00
00:00
08:00
08:00
08:00
08:00
06:00
08:00
00:00
06:00
08:00
08:00
08:00
08:00
08:00
00:00
08:00
08:00
08:00
08:00
08:00
08:00
00:00
08:00
08:00
8 hours days worked
22 below should read 22
per daily8 hours worked 00:00
-----------------------------------------------------------------
Vic
Apr 22, 2009 at 01:47 AM