+ Reply to Thread
Results 1 to 2 of 2

adding time from 2 cells in 3rd cell=#VALUE error

  1. #1
    Registered User
    Join Date
    05-30-2014
    Location
    Lima, Peru
    Posts
    31

    Question adding time from 2 cells in 3rd cell=#VALUE error

    Hi all.
    I'm trying to add (Formate) m/d h:mm, with =TODAY() in R26, with
    (Formate) d h:mm in S26......

    Formula '=R26+S26' in cell U26

    all I get is #VALUE

    Purpose: after entering the d h:mm value to S26, I need U26 to give me the m/d h:mm value, which is the format of the cell.
    It's to give me the day and time that I need to attend to something that is expiring and needs to be renewed/reactivated.

    I've tried 'S26=(NOW()+S26); S26=NOW()+S26; S26=NOW()+(S26)

    anyone?
    Attached Files Attached Files
    Last edited by Mr.GfCs; 04-23-2020 at 01:02 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,036

    Re: adding time from 2 cells in 3rd cell=#VALUE error

    Your value in S26 is text not a number. What is 3 4:23 supposed to be ? a date and time? a number of days and time?
    Text aligns left and numbers ( dates are in fact numbers ) align right. When you manually align the contents of cell the information given by their position is lost
    Be aware that NOW() returns date AND actual time, so the result will change when the sheet refreshes

+ 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. [SOLVED] Why am I Getting a Run-time Error '91' error after adding CurrentUser to code below?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 06-14-2015, 06:24 PM
  2. run time error adding values to worksheet
    By sabrinamay16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2013, 01:18 PM
  3. Excel 2007 : #VALUE! error when adding time
    By jhendrix in forum Excel General
    Replies: 3
    Last Post: 01-15-2010, 07:14 PM
  4. Run time error 1004 when adding rows
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2009, 07:35 AM
  5. Adding Time: Adding individual cells works, but SUM doesn't
    By fredmeister in forum Excel General
    Replies: 17
    Last Post: 04-11-2008, 10:40 AM
  6. [SOLVED] Run time error '-2147467259 (80004005) adding icon
    By DMc2005 in forum Excel General
    Replies: 3
    Last Post: 10-02-2005, 12:05 PM
  7. Run time error '-2147467259 (80004005) adding icon
    By DMc2005 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2005, 12:05 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