Previous Topic Next Topic

Counting cell with specific time

Closed
Vic - Apr 2, 2009 at 09:17 AM
 vic - May 3, 2009 at 11:18 PM
Hello,

I need to count how many times 08:00:00 AM appears in a row of cells.

Note this is a time format.

Anyone can help greatly apprieciated.

Vic
Related:

3 responses

Answer 1 / 3
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
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 ...
0
Vic
Apr 15, 2009 at 08:33 PM
Thankyou for your help, i tried it out.But answer is 0.?
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
0
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165 > Vic
Apr 22, 2009 at 01:47 AM
Change the cell format of the cell where you have entered the formula !!!!! make it number
0
Answer 2 / 3
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Apr 22, 2009 at 01:44 AM
Its working nicely with me...... change the cell format of Resulting Cell from Format > Cell > General> Number
0
vic
May 3, 2009 at 11:18 PM
Hi aziz as i said this formula is working fine it counts all the 8hrs and hours above 8.

What if i want it only to count the ones written in black.

=COUNTIF(B678:B708,">=08:00:00 am")
0
Answer 3 / 3
vic
Apr 22, 2009 at 05:31 AM
Thank you very much for your help.
Yes it has worked and i have also add a little for hours worked over 8.

=COUNTIF(B678:B708,">=08:00:00 am")
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses