+ Reply to Thread
Results 1 to 4 of 4

x2 IF functions, hidden until needed, and a time formula

  1. 06-01-2020, 05:17 PM #1
    Hurg
    Hurg is offline
    Registered User
    Join Date
    05-17-2020
    Location
    Reading, England
    MS-Off Ver
    2019
    Posts
    17

    x2 IF functions, hidden until needed, and a time formula

    Hello,

    • Column C need to be hidden until column B has something entered
    • Time/ date in Column A is entered
    • one of three options is chosen in column B
    • Column C then EITHER does a time calculation of adding 1 or 24 hours if 1 or 24 is selected in B OR it sets the time to 12pm of the day the formula takes place if WKND is selected in B

    Sample sheet attached.

    Hurg
    Attached Files Attached Files
    Last edited by Hurg; 06-01-2020 at 05:22 PM.
    Reply With QuoteRegister To Reply
  2. 06-01-2020, 05:34 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: x2 IF functions, hidden until needed, and a time formula

    Try this, copied down...
    =IF(A2="","",A2+IF(B2="WKND",2,B2/24))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-01-2020, 05:48 PM #3
    Hurg
    Hurg is offline
    Registered User
    Join Date
    05-17-2020
    Location
    Reading, England
    MS-Off Ver
    2019
    Posts
    17

    Re: x2 IF functions, hidden until needed, and a time formula

    Hello,

    Thanks for the reply. However it isn't quite what it needs to be, the WKND option needs to show [today's date] 12:00:00 in column C

    Hurg
    Reply With QuoteRegister To Reply
  4. 06-01-2020, 11:42 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: x2 IF functions, hidden until needed, and a time formula

    OK, so did you try adjusting my suggestion?
    You have the basis of what you need, just the last part is wring
    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] If formula for when time is needed for set shifts
    By murray83 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-09-2017, 03:52 PM
  2. Can VLOOKUP decipher entries per person and return tally results or deduct from allowance?
    By NDNLAWCOLORADO in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2017, 03:18 PM
  3. Over time formula needed
    By Russ15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-26-2015, 10:04 PM
  4. Military Time Formula Needed
    By BubbasExcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-01-2013, 11:14 PM
  5. Excel 2007 : Time formula needed
    By nanlag in forum Excel General
    Replies: 4
    Last Post: 04-27-2012, 04:56 PM
  6. any macro with 10 formula and functions is needed
    By kemo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-28-2009, 08:36 AM
  7. working time and over time formula needed please
    By Crasher in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 10-09-2006, 08:48 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