+ Reply to Thread
Results 1 to 1 of 1

Calculate time based on eight hour day minus weekends

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    272

    Calculate time based on eight hour day minus weekends

    In the attached workbook, I'm trying to calculate median time duration of jobs. The current formula calculates median time minus weekends based on a 24 hour day. Is it possible to do this based on an eight hour day? Here is the current formula:
    HTML Code: 
    Any help is greatly appreciated!
    Sick
    Attached Files Attached Files

+ 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. Calculate Hours Worked, Minus Weekends
    By Violator in forum Excel General
    Replies: 13
    Last Post: 11-15-2009, 05:02 AM
  2. calculate a 24 hour cycle time which excludes weekends and public holidays
    By rammergu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2009, 05:44 AM
  3. Replies: 4
    Last Post: 01-25-2009, 11:25 AM
  4. [SOLVED] Calculate Number of Days Between Dates Minus Weekends
    By Melissa in forum Excel General
    Replies: 3
    Last Post: 03-06-2006, 03:25 PM
  5. how to calculate elapsed time (minus weekends/holidays)?
    By blizard in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-02-2005, 10:19 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