average by time

  1. S

    Average if Formula Help

    Hello. how can i add weekday to the formula below. right now the formula im using is giving me the average interval, i need it to say per weekday per interval . im trying to get the average for all mondays in the year at 8:30 am. {=AVERAGE(IF(($A$2:$B$18927)=$E2,$C$2:$C$18927))} a...
  2. T

    Calculate average times

    Hi, i'm having a hard time working out average pageview times on a website. I've already had a look on a number of posts but nothing seems to work, i've tried right-clicking the data range and formatting to time or custom as hh:mm:ss as my times are displayed as hours mins secs. I've tried the...
  3. K

    Count overlapping times on a moving 30 min window

    I searched the forums for a similar question and did not see one that helped with this question. I need to know on average how many airplanes are on the ground at the same time during the day. To get an accurate number it needs to look 30 minutes ahead of and behind the departure time and...
  4. N

    Averaging 24hr times

    Hi Guys, I am having some trouble getting an average time when the times are across a 24hr period. For instance if these were the following times of medication consumption, the early AM times bring the average way down as if the later PM times were later on the same day. However, I need to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top