Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average if between 2 diffrent times
Help
I need help. I need the average between 8:00 AM - 8:15 A.M., 8:15 A.M. - 8:30 A.M. and so on in 15 Min intervals Can someone please help me build a formula to compute and avg. between those times please. ty A B C D E 1 Seconds Times between and Answere avg. 2 150 8:11:59 8:00 AM 8:15 AM 275 3 400 8:09:40 8:15 AM 8:30 AM 400 4 200 8:18:01 5 600 8:30:00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average if between 2 diffrent times
Hi,
Am Fri, 24 Aug 2018 10:27:31 -0700 (PDT) schrieb : A B C D E 1 Seconds Times between and Answere avg. 2 150 8:11:59 8:00 AM 8:15 AM 275 3 400 8:09:40 8:15 AM 8:30 AM 400 4 200 8:18:01 5 600 8:30:00 try in E2: =AVERAGEIFS($A$2:$A$10,$B$2:$B$10,""&C2,$B$2:$B$1 0,"<="&D2) and copy down. Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average if between 2 diffrent times
Worked like a charm thank you
On Friday, August 24, 2018 at 12:45:09 PM UTC-5, Claus Busch wrote: Hi, Am Fri, 24 Aug 2018 10:27:31 -0700 (PDT) schrieb : A B C D E 1 Seconds Times between and Answere avg. 2 150 8:11:59 8:00 AM 8:15 AM 275 3 400 8:09:40 8:15 AM 8:30 AM 400 4 200 8:18:01 5 600 8:30:00 try in E2: =AVERAGEIFS($A$2:$A$10,$B$2:$B$10,""&C2,$B$2:$B$1 0,"<="&D2) and copy down. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to average times in a column | Excel Worksheet Functions | |||
Need to average clock times | Excel Worksheet Functions | |||
average of times | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Formula to Average times...again | Excel Discussion (Misc queries) |