 |
|
| uk.sci.weather (UK Weather) (uk.sci.weather) For the discussion of daily weather events, chiefly affecting the UK and adjacent parts of Europe, both past and predicted. The discussion is open to all, but contributions on a practical scientific level are encouraged. |
|
|
LinkBack | Thread Tools | Display Modes |
|
#1
February 29th 04, 05:50 PM
posted to uk.sci.weather
|
|||
|
|||
Excel help :-)
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel template for recording daily local weather. | uk.sci.weather (UK Weather) | |||
| (OT) Excel help | uk.sci.weather (UK Weather) | |||
| [OT] Excel help | uk.sci.weather (UK Weather) | |||
| OT Excel ? | uk.sci.weather (UK Weather) | |||
| O/T Excel Help | uk.sci.weather (UK Weather) | |||
Threaded Mode
