+ Reply to Thread
Results 1 to 2 of 2

How to Average per Hour/Day/Month/Quarter/Year

  1. #1
    Registered User
    Join Date
    07-23-2017
    Location
    Wroclaw, Poland
    MS-Off Ver
    2015
    Posts
    11

    How to Average per Hour/Day/Month/Quarter/Year

    Hello,

    I would like to ask how to calculate average timestamps, amounts of MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR in unequal intervals?

    Attached file.

    Thank you for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,944

    Re: How to Average per Hour/Day/Month/Quarter/Year

    It might help us understand what you want if you could tell us the manually calculated value that should appear in cell G2, so that we will have something with which to compare the results of our proposed formulas/code.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sumproduct occurrences occurring by Month, Quarter & Year
    By jolthof in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-05-2018, 12:27 AM
  2. [SOLVED] Convert year month to year quarter
    By yllew in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-06-2018, 03:04 AM
  3. [SOLVED] Splitting my data by month, year and quarter
    By heytherejem in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 03-14-2018, 03:25 PM
  4. SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR
    By faodavid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2017, 02:53 PM
  5. How to sum data by month, by quarter, by year?
    By kevinSHR in forum Excel General
    Replies: 3
    Last Post: 05-06-2016, 04:06 PM
  6. [SOLVED] Month/quarter/semestre/year calculations
    By pccamara in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-05-2016, 08:37 AM
  7. Expanding 4th quarter by month ONLY for certain year
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-28-2013, 06:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1