Posted to microsoft.public.excel.worksheet.functions

S.C

external usenet poster

Posts: 6

Countif time

I have a column of time (0:08) I would like to count the amount of times the
time of 0:08 (for example) but I cannot get my formula of
=COUNTIF(S4:S128,"0:08") to count. This column is a subtraction of two times
=B4-E4, I copy and Paste Special the value into column "S"

Thanks in advance for the assistance
Steve

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif time is between two nominated times	hopeless in excel	Excel Worksheet Functions	2	April 20th 06 11:33 PM
Help with CountIf < and time formula please	Stu Leslie	Excel Worksheet Functions	1	March 31st 06 03:41 PM
Help with CountIf < and time formula please	bpeltzer	Excel Worksheet Functions	0	March 26th 06 11:44 PM
Using Countif to count occurences of time?	Liketoknow	Excel Worksheet Functions	5	February 6th 06 08:21 AM
COUNTIF use with fields of time	sshakley	Excel Worksheet Functions	2	December 1st 05 06:48 PM

All times are GMT +1. The time now is 05:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us