Results 1 to 8 of 8

Working days and hours only

Threaded View

  1. #3
    Registered User
    Join Date
    04-03-2012
    Location
    Riyadh
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Working days and hours only

    Thank you very much Fotis1991 for the prompt reply

    So here where I stand. I took this formula and changed the work day start and end hours from

    =(18/24-MOD(A1,1)+MOD(A2,1)-9/24)*24 + (NETWORKDAYS(A1,A2)-2)*9

    to

    =(17/24-MOD(A1,1)+MOD(A2,1)-8/24)*24 + (NETWORKDAYS(A1,A2)-2)*9

    It's not giving me what i want.

    * I know that NETWORKDAYS is excluding Saturdays and Sundays so I think I have to add something to change that
    * The calculation should exclude anything before 8 Am and exclude anything after 5 PM

    Note: A1= 07/09/2013 9:30:00 AM
    A2= 13/09/2013 4:00:00 PM
    The result should be 45 hours
    Last edited by malbarki; 09-19-2013 at 02:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-13-2013, 05:19 AM
  2. Calculating working days AND hours
    By Pearl_Jam in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-07-2013, 02:28 PM
  3. Replies: 4
    Last Post: 11-30-2011, 03:25 PM
  4. Working out hours between days
    By Loisw in forum Excel General
    Replies: 1
    Last Post: 08-04-2009, 03:06 AM
  5. Network days/working Hours
    By Kolacube in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2008, 09:36 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