Hello All:
I am looking for some help here….I have a series of spreadsheets
coming to me that I need to have it do a daily average. The
spreadsheet is hourly record of water level for various wells. I have
been using macros to get this going but have been unsuccessful. The
full day is consist of 24 reading one for each hour, given that we
have full day sometimes is less and that is part of my problem. The
daily avg is the sum of DTW_AF/by the number of readings. I run into
problem when I want the code to find the beginning and the end of the
day by date and hour and have the code do a count of records to use
for the divide part of the avg………


A B C D E F
G H I J K
Date time hours psi corrected_pm Temp Level_D +/-
DTW DTW_AF Daily Avg
1
2
3
etc

Ardy