Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 24th 18, 06:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 14
Default 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   Report Post  
Old August 24th 18, 06:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,625
Default 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   Report Post  
Old August 24th 18, 06:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 14
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to average times in a column Jerry58 Excel Worksheet Functions 8 March 6th 08 07:23 PM
Need to average clock times Tall Texan Excel Worksheet Functions 1 February 5th 08 04:59 PM
average of times m greenly Excel Discussion (Misc queries) 4 March 23rd 07 03:37 PM
Formula to average certain times Denise Excel Discussion (Misc queries) 5 July 18th 05 01:02 PM
Formula to Average times...again Denise Excel Discussion (Misc queries) 1 July 15th 05 08:26 PM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017