+ Reply to Thread
Results 1 to 2 of 2

Average of ending time in a columns

  1. #1
    Registered User
    Join Date
    06-24-2012
    Location
    mauritius
    MS-Off Ver
    Excel 2007
    Posts
    7

    Average of ending time in a columns

    Hi All
    Im having a headache to calculate the average of ending time in a column.
    I would like some help in this matter, below is a list of ending time by an employee
    I would like to know in average which time does he ends in general

    01:20
    23:40
    22:50
    00:50
    23:25
    22:46
    01:36

    how to calculate the average time he ends every day

    Thanking you
    Ludovic

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Average of ending time in a columns

    If the times are just times and there is no date element
    as an array with shift ctrl enter

    =MOD(AVERAGE(IF(A1:A7<0.5,A1:A7+1,A1:A7)),1)

    so if the shift finishes in the first half of the day <0.5 I assume it goes over midnight

    If the average finish time is after midnight the value will be for example 1.00034 so the mod function, changes this to 0.00034

    think that's all!
    Last edited by davsth; 06-11-2019 at 03:43 AM.

+ 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. Index/Match to find Starting Point of Average, Ending Point of Average Variable
    By tgentry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 01:04 AM
  2. Replies: 1
    Last Post: 03-12-2012, 12:09 PM
  3. how to code a userform to take average of row starting and ending at selcted dates
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2011, 11:54 AM
  4. Can't sort time data for values ending in '0'
    By Antarctic-Excel in forum Excel General
    Replies: 3
    Last Post: 11-28-2011, 01:39 PM
  5. Never ending time sheet
    By Ltat42a in forum Excel General
    Replies: 14
    Last Post: 11-26-2008, 07:49 AM
  6. Ending application on time macro
    By phil2006 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2008, 06:05 PM
  7. Charts with setting starting and ending point on x (time)
    By yuri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2008, 08:28 AM

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