+ Reply to Thread
Results 1 to 3 of 3

Multiple values one cell and formula in another

  1. #1
    Registered User
    Join Date
    09-27-2017
    Location
    OMAHA, NE
    MS-Off Ver
    2013
    Posts
    6

    Question Multiple values one cell and formula in another

    I am trying to modify a spreadsheet that I have where I have to log changed times. To do this, it is requested that these times be in the same cell. This cell shows the original time on top of the new time via ALT+Enter. There is a second cell that has a formula to take the time from that cell and subtracts a specific ammount of time, such as 30 minutes. Obviously this no longer works with having 2 times in one cell... How would I go about making this work where I can have either a new time (not the original) or both times shown in the cell that has the formula showing the times 30 minutes earlier?

    I consider myself pretty excelled at excel but this one has me stumped.

    Example: Cell A1 has the formula for Cell B1-30 minutes. Cell B1 originally had one time in it and the formula in A1 worked fine, that time has been changed so now B1 has 2 times in it and cell A1 no longer shows anything.

    Thanks in advance!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,601

    Re: Multiple values one cell and formula in another

    =if(len(a1)=11,right(a1,5)-left(a1,5),a1-"00:30:00")*24
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-27-2017
    Location
    OMAHA, NE
    MS-Off Ver
    2013
    Posts
    6

    Re: Multiple values one cell and formula in another

    You Rock! I really thank you for that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple line values in a single cell - to use in formula
    By skastroman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2017, 06:31 AM
  2. [SOLVED] Formula to Return cell value based on multiple Max & Min values
    By hecgroups in forum Excel General
    Replies: 10
    Last Post: 08-27-2017, 03:08 PM
  3. [SOLVED] formula to return multiple values in single cell not working
    By judiejean in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-11-2017, 11:45 AM
  4. [SOLVED] Need countifs formula for multiple values in single cell
    By hmr2662 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2016, 11:02 AM
  5. [SOLVED] Need help with Formula to change multiple cell's values - Example Attached
    By rufus40444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2013, 04:52 PM
  6. Replies: 3
    Last Post: 01-28-2011, 03:19 AM
  7. Replies: 6
    Last Post: 06-08-2010, 09:42 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