| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate the third friday of a month? | Excel Worksheet Functions | |||
| How do I calculate the friday before a date? | Excel Discussion (Misc queries) | |||
| Formula to display next Friday from B1 works except on the Friday itself. | Excel Discussion (Misc queries) | |||
| How to calculate lead time excluding Friday and Saturday | Excel Discussion (Misc queries) | |||
| Friday | New Users to Excel | |||
Linear Mode
