Results 1 to 7 of 7

Need to convert schedule from workday to "now" or hours

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Washington US
    MS-Off Ver
    Windows 365
    Posts
    31

    Need to convert schedule from workday to "now" or hours

    I have a attached a schedule that I need to improve. (the only relevant tab is "Eastern, and I have made the affecting formula header black and the input time in red)

    What i need to do is instead of utilizing "projected run time in days" (Column P) , I need this to be in hours (or even minutes). Hours are preferred. The problem i have had is that I cannot get the intended dates in column A & R because they are based on workday function. Hours were always preferred but using Workday & Today for this schedule was all I was able to achieve thus far. Please note that columns N & O also contribute to this equation.

    So to summarize, I need:

    Column A & Column R (Projected finish /delivery dates) need to have the same results as current (or can include time and minutes) except that I need it to be based on hours or minutes entered into Column P (Run time)
    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. [SOLVED] Brief formula to convert time values to "shift1", "shift2", "shift3".
    By darekpawel in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-11-2019, 07:05 AM
  2. [SOLVED] Convert from "general" (YYYYMMDD) to specific "custom" format (YYYY.MM.DD)
    By Ella_p in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2013, 02:23 AM
  3. [SOLVED] Excel 2007: How to Convert "5/2/2013" to "May" then subtract a Month so it's "Apr"
    By Golom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 02:00 AM
  4. Replies: 8
    Last Post: 12-31-2012, 05:19 PM
  5. Convert "Time Interval" in "hours : minutes : seconds" to seconds
    By deano27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 09:07 AM
  6. [SOLVED] time:how can i convert "22 hours 23 minutes" into 22:23 ?
    By Gary in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2006, 05:50 AM
  7. Replies: 7
    Last Post: 05-08-2005, 04:06 PM

Tags for this Thread

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