Results 1 to 8 of 8

Calculate workday date and time based on hours

Threaded View

  1. 02-19-2019, 03:23 PM #1
    rdd2
    rdd2 is offline
    Registered User
    Join Date
    02-05-2009
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    30

    Calculate workday date and time based on hours

    Column B = projected hours
    Column C = actual hours
    Column D = start date
    Column E = finish date based on projected, then actual

    Objective: Finish date to calculate based on projected hours for current and all future work orders listed. Start and finish dates automatically adjust based on actual hours. Weekends and non-working hours excluded.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Project Workday End Date and Time Based on Duration
    By nrschmid in forum Excel General
    Replies: 5
    Last Post: 02-26-2017, 01:12 PM
  2. Calculate end date and time (working hours)
    By ded1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-03-2016, 07:41 AM
  3. VBA to Calculate Start Date from End Date and Dev Time Using WORKDAY()
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2014, 05:06 PM
  4. [SOLVED] Calculate number of hours from Start date and time and End date and time
    By sathyasun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 01:04 AM
  5. Need formula to calculate time in hours between two date ranges
    By annyfouanny in forum Excel General
    Replies: 7
    Last Post: 06-27-2011, 06:19 AM
  6. calculate number of hours between two date/time combinations
    By smokebreak in forum Excel General
    Replies: 2
    Last Post: 01-21-2010, 11:09 AM
  7. Calculate total Hours between 2 date and time
    By Tylim in forum Excel General
    Replies: 3
    Last Post: 05-08-2006, 10:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1