Results 1 to 15 of 15

average time based on clock time range

Threaded View

xrayexceller average time based on clock... 07-19-2013, 10:26 PM
FDibbins Re: average time based on... 07-20-2013, 01:46 AM
Tony Valko Re: average time based on... 07-20-2013, 09:53 AM
FDibbins Re: average time based on... 07-20-2013, 05:15 PM
daddylonglegs Re: average time based on... 07-20-2013, 06:14 PM
Tony Valko Re: average time based on... 07-20-2013, 06:16 PM
FDibbins Re: average time based on... 07-20-2013, 06:21 PM
Tony Valko Re: average time based on... 07-20-2013, 06:26 PM
xrayexceller Re: average time based on... 07-23-2013, 12:11 PM
Tony Valko Re: average time based on... 07-23-2013, 03:48 PM
daffodil11 Re: average time based on... 07-23-2013, 12:18 PM
xrayexceller Re: average time based on... 07-23-2013, 12:56 PM
daffodil11 Re: average time based on... 07-23-2013, 01:38 PM
xrayexceller Re: average time based on... 07-23-2013, 06:07 PM
Tony Valko Re: average time based on... 07-23-2013, 06:40 PM
  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    24

    average time based on clock time range

    I would like to average clock times that fall within a specific time frame.

    I have already calculated an elapsed time with a formula but want to find the average time between 8:00 and 20:00 and between 20:01 and 7:59.
    Any ideas?

    Thanks in advance

    Performed time Ordered to radiology report (min)
    7:20 37
    8:59 61
    14:24 99
    17:34 105
    17:47 939
    19:19 77
    22:46 52
    22:48 66
    23:06 47
    Last edited by xrayexceller; 07-23-2013 at 06:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split Shift & Time Managment Grid based on 24 hour clock in 15 min increments
    By paxile2k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2013, 08:23 PM
  2. Average of time range
    By DexterG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2012, 08:20 AM
  3. Replies: 3
    Last Post: 09-29-2007, 04:58 PM
  4. [SOLVED] How do I add a duration time value and a clock time value?
    By sueb262 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2006, 05:45 PM
  5. Replies: 6
    Last Post: 08-04-2005, 08:05 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