Calculate Mon-Friday (8AM-5PM)
 

I have a spreadsheet that has 14,000 rows with numerous fields.

The data is sampled every minute which is A field in the spreadsheet.

I would like to write a formula that would
average the data using Monday - Friday and 8AM - 7PM for columns B - AC.

Thanks,

Calculate Mon-Friday (8AM-5PM)
 

Joe,

What column is being averaged?

Presumably column B is the date/time?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe K." <Joe wrote in message
...

I have a spreadsheet that has 14,000 rows with numerous fields.

The data is sampled every minute which is A field in the spreadsheet.

I would like to write a formula that would
average the data using Monday - Friday and 8AM - 7PM for columns B - AC.

Thanks,