+ Reply to Thread
Results 1 to 2 of 2

Adding time values for no sequence cells with an IF function

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Exclamation Adding time values for no sequence cells with an IF function

    I need help please adding times values as follows:
    If cell A1 contains (AAA or BBB) to add three hours to cell B1. If cell A1 contains (CCC or DDD to add two hours instead to cell B1
    Cell B1 contains time values, example 25/05/2011 20:40:00
    I tried the below formula but it reflected an error.

    =IF((OR(A1="AAA",A1="BBB"),(B1+TIME(3,0,0),"")),IF((OR(A1="CCC",A1="DDD"),(B1+TIME(2,0,0""))
    Last edited by Khaldon; 05-22-2011 at 04:41 AM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Adding time values for no sequence cells with an IF function

    Try
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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