+ Reply to Thread
Results 1 to 3 of 3

Add time (minutes) mins or leave cell blank

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    Leeds, Endland
    MS-Off Ver
    Excel 2007
    Posts
    12

    Add time (minutes) mins or leave cell blank

    So, cell A1 has the time (09:00), cell A2 has the minutes (60), cell A3 is the sum of A1+A2.

    Im using this formula =A1+TIME(0,A2,0) - which is fine, except A1 is sometimes blank, so therefore I would like A3 to be blank.

    I thought I could use this: =IF(A1,"","",(A1+TIME(0,A2,0)) But it doesn't work. Any help is appreciated.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,443

    Re: Add time (minutes) mins or leave cell blank

    Try =IF(A1="","",A1+TIME(0,A2,0))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    11-12-2011
    Location
    Leeds, Endland
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Add time (minutes) mins or leave cell blank

    Thank you, so obvious now you pointed it out.

+ 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. Sick leave annual leave minutes spreadsheet
    By News12kim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2013, 03:28 AM
  2. [SOLVED] conditional formatting time and leave other blank
    By jekidi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-08-2013, 11:09 AM
  3. Replies: 3
    Last Post: 05-22-2012, 03:26 PM
  4. Time Converter : Mins/Secs to Hours/Mins
    By jamesgsi1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 09:02 AM
  5. Replies: 8
    Last Post: 01-07-2006, 03:35 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