+ Reply to Thread
Results 1 to 3 of 3

Excel Workday Formula

  1. #1
    Registered User
    Join Date
    04-12-2006
    Posts
    30

    Excel Workday Formula

    I have a formula in a cell that calculates times.
    =WORKDAY($R3,INT(E3/$G$1)+1)
    Column R3 is the start date.
    E3 is number of hours a job takes to run
    G1 is number of hours available

    The formula is supposed to take the start date, add the number of hours a job is to run, divide it by the number of hours available to run and come up with a end date.

    It used to work, however, now it is making all end dates the next day at 12:00 am.

    Help

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If E3 is less than G1, that's what the formula does. And assuming R3 is a date only (no time), it will always give a minight result.

    I don't understand the formula in the context of what you want it to do.

  3. #3
    Registered User
    Join Date
    04-12-2006
    Posts
    30

    Workday Formula

    Column S3 is the starting date and time. E3 is the number of hours. G1 is the number of available hours.

    We want to take the starting date, hours, then divide by the number hours available to give us an ending date.

    Hope this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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