Previous Topic Next Topic

Counting cell with specific time

Closed
Vic - 2 Apr 2009 à 09:17
 vic - 3 May 2009 à 23:18
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

Réponse 1 / 3
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
13 Apr 2009 à 03:16
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 ...
Vic
15 Apr 2009 à 20:33
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
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166 > Vic
22 Apr 2009 à 01:47
Change the cell format of the cell where you have entered the formula !!!!! make it number
Réponse 2 / 3
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
22 Apr 2009 à 01:44
Its working nicely with me...... change the cell format of Resulting Cell from Format > Cell > General> Number
vic
3 May 2009 à 23:18
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")
Réponse 3 / 3
vic
22 Apr 2009 à 05:31
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")

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

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

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses