Results 1 to 11 of 11

Excel 2007 : Workday Formula with Workhours

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    New York NY
    MS-Off Ver
    Excel 2003
    Posts
    5

    Workday Formula with Workhours

    Hi,

    I am trying to output the end date using the formula workday, but I need to only include 9 AM - 6 PM working hours.

    For example, if start date is 4/18/11 at 3:00 PM and the next deliverable is 2 days following, the output would be 4/20/11 at 3:00 PM.

    See sample attached.

    Thanks!
    Attached Files Attached Files

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