+ Reply to Thread
Results 1 to 4 of 4

Find the end date & time considering work hours

Hybrid View

  1. #1
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,706

    Re: Find the end date & time considering work hours

    based on your sample one option below (which will return your expected result):

    Formula: copy to clipboard
    C7:
    =WORKDAY($C$5,CEILING(($C$6+MOD($C$5,1)-$C$3)/($D$3-$C$3),1)-1)+MOD($C$5,1)+$C$6-CEILING(MOD($C$5,1)+$C$6-$C$3,$D$3-$C$3)+$D$3-$C$3
    format as m/d h:mm:ss AM/PM
    the above is an approach provided by an old poster here (daddylonglegs)

  2. #2
    Registered User
    Join Date
    03-23-2017
    Location
    Orange, CA
    MS-Off Ver
    2010
    Posts
    14

    Re: Find the end date & time considering work hours

    Thank you! Worked out perfectly.

+ 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. Replies: 11
    Last Post: 11-18-2016, 09:25 AM
  2. Replies: 8
    Last Post: 01-31-2016, 10:14 AM
  3. Replies: 12
    Last Post: 01-25-2016, 10:53 AM
  4. Replies: 3
    Last Post: 04-04-2013, 06:12 PM
  5. [SOLVED] How do i calculate work hours from only a start and finish date and time?
    By transitsolutions in forum Excel General
    Replies: 1
    Last Post: 02-28-2013, 03:39 PM
  6. Replies: 0
    Last Post: 11-12-2012, 04:49 AM
  7. "Time" problem: Need function to find time&date - ?hours
    By Powrpak in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2008, 08:15 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