+ Reply to Thread
Results 1 to 7 of 7

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

  1. 11-10-2020, 12:22 PM #1
    Dawn Clark
    Dawn Clark is offline
    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
    Reply With QuoteRegister To Reply
  2. 11-10-2020, 12:28 PM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,073

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

    How are you currently calculating the number in P?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 11-10-2020, 12:32 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,073

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

    OK - I see now (I think).

    If P2 is in hours, them this in A2:

    =WORKDAY(TODAY(),((SUM(P$2:P2,(IF(N2="Yes",72,P2))+(IF(O2="Yes",168,P2))))/24))

    If P2 is in minutes, then this in A2:

    =WORKDAY(TODAY(),((SUM(P$2:P2,(IF(N2="Yes",72*60,P2))+(IF(O2="Yes",168*60,P2))))/(24*60)))
    Reply With QuoteRegister To Reply
  4. 11-10-2020, 12:46 PM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

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

    HI,

    Assuming Hours are in P2 then

    A2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    R2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  5. 11-10-2020, 03:17 PM #5
    Dawn Clark
    Dawn Clark is offline
    Registered User
    Join Date
    11-13-2018
    Location
    Washington US
    MS-Off Ver
    Windows 365
    Posts
    31

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

    Column P is manually entered by operators
    Reply With QuoteRegister To Reply
  6. 11-11-2020, 08:20 AM #6
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

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

    Quote Originally Posted by Dawn Clark View Post
    Column P is manually entered by operators
    Indeed, that's what I understood since that's what you mentioned in your OP.
    Reply With QuoteRegister To Reply
  7. 12-05-2020, 03:12 PM #7
    Dawn Clark
    Dawn Clark is offline
    Registered User
    Join Date
    11-13-2018
    Location
    Washington US
    MS-Off Ver
    Windows 365
    Posts
    31

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

    Thanks so much! This worked
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [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. Using IF-THEN-ELSE to convert "M" to "Mr", "F" to "Ms" ELSE leave "Blank".
    By Midwicket in forum Excel - New Users/Basics
    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. 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. [SOLVED] [SOLVED] Convert "Time Interval" in "hours : minutes : seconds" to seconds
    By Ianukotnorth in forum Excel - New Users/Basics
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1