|
|
|
|
#1
05-25-2010, 12:35 PM
|
|||
|
|||
Thats wpuldnt get me the correct answer though, as I need to average on the timestamp, and make sure it is a weekday. So I at least need an AVERAGEIFS() with two conditions. Thus I need to look at the value at noon on every weekday for a whole month (larger data set not shown) and return THAT value. 
|
|
#2
05-25-2010, 01:49 PM
|
||||
|
||||
|
I had to modify how you determine the minutes from day start since Excel will have problems comparing numbers with extreme decimals.
Anyway, give this a try: Cheers,
|
|
#3
05-25-2010, 01:58 PM
|
|||
|
|||
|
Quote:
|
|
#4
05-25-2010, 02:32 PM
|
|||
|
|||
|
Sorry thought it would be clear from the formula that it also had to be reading the timestamp...
Didnt mean to come across as rude. 
|
|
| Tags |
| average if, cse, weekday |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 lastincolumn function
|
rdcsfd | Excel Programming | 7 | 02-08-2012 07:50 AM |
|
FIND function, where?
|
Yumin | Word | 2 | 04-02-2010 07:16 PM |
|
Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
|
Need help on what function to use???
|
Primeraman | Excel | 1 | 06-13-2006 10:16 AM |
| Help with Combination function | sanasath | Excel | 0 | 12-13-2005 07:24 AM |
Windows XP 
Office 2007
Hybrid Mode