Just the job, many many thanks Chris.

That gave me 707 cells containing Zeros or less, which equated to 3535
minutes (707 x 5) 5 being the time interval that my WMII is set at.

divided by 60 to give hours (3535/60 = 58.91666667)
then for the decimal bit .91666667 x 60 / 100 = 0.55 minutes.

Total time 58 hours 55 minutes.

Keith (Southend)

********************************
'Weather Home & Abroad'
http://www.southendweather.net
********************************
COL Station for Southend-on-Sea
http://www.wunderground.com/weathers...p?ID=IESSEXSO1
********************************
Reply to: kreh'at'southendweather'dot'net
All mail scanned for virus's using Norton 2003


On Sun, 29 Feb 2004 18:59:20 +0000,
wrote:

I would use the countif statement
for example
=COUNTIF(A1:A9,"=0")

will give you the amount of cells containing a number equal to or less
than 0 between the range A1 and A9, modify the range for your own
table.

Hope this helps

Chris


On Sun, 29 Feb 2004 18:50:03 +0000, "Keith (Southend)"
wrote:

I wonder if someone can help me with a little 'excel' problem. For my
COL data I need to be able work out how many hours of Air Frost there
has been in the month. I can 'export' data from wy WMII into excel,
but then want a formula that can count the toal number of cells, in a
column, that contain numbers that are '0' or below (-0.1, -0.2.. etc)
From this I can then determine the total hours/minutes of air frost,
as each number represents a 5 minute interval.

Keith (Southend)

********************************
'Weather Home & Abroad'
http://www.southendweather.net
********************************
COL Station for Southend-on-Sea
http://www.wunderground.com/weathers...p?ID=IESSEXSO1
********************************
Reply to: kreh'at'southendweather'dot'net
All mail scanned for virus's using Norton 2003