Results 1 to 4 of 4

Find the end date & time considering work hours

Threaded View

ralphp312 Find the end date & time... 04-09-2020, 12:25 AM
XLent Re: Find the end date & time... 04-09-2020, 02:53 AM
ralphp312 Re: Find the end date & time... 04-10-2020, 07:04 PM
AliGW Re: Find the end date & time... 04-11-2020, 02:35 AM
  1. #1
    Registered User
    Join Date
    03-23-2017
    Location
    Orange, CA
    MS-Off Ver
    2010
    Posts
    14

    Find the end date & time considering work hours

    I need a formula where I have a determined start time + planned dd:hh:mm equals the end time with consideration of 1) work hours, 2) holidays & weekends excluded.

    Example:
    Work Hours = 5:45 AM to 10:00 PM (M-F)
    Start Date/Time = 4/8/20 9:37 AM
    Planned Time = 1:14:28 (formatted as: dd:hh:mm)
    End Date/Time = 4/10/20 2:58 PM (how to get this result)
    Attached Files Attached Files

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