Calculate Mon-Friday (8AM-5PM)

[Joe K.]

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,

[Bob Phillips]

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 [email protected]> wrote in message
news:[email protected]...
>
> 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,
>
>