Excel - computing Hours and minutes question

Posted on 2012-08-20
Last Modified: 2012-08-20
I have a cell that has 9:30 am and need to add 40 minutes to it.  How do I do this?  If I add 40 to the cell containing 9:30 am, I get 9:30 am plus 40 days.  

... I'm trying to understand time arithmetic in Excel.
Question by:brothertruffle880
    LVL 19

    Expert Comment

    by:Ken Butters

    New time = current time + Time(hours,minutes,seconds)

    so to add 40 minutes....


    .... or "9:30" could reference cell A1 for example... if cell A1 had 9:30 in it.
    LVL 9

    Expert Comment

    by:Evan Cutler
    What's the cell formatted?  Date?

    if Date, and time is included with date:

    DateAdd("n", 5, field)  </-- adds five minutes-->

    LVL 19

    Accepted Solution

    supposing cell a1 had 9:30 in it...

    you could use the following formula : =A1+time(,0,40,0)
    LVL 11

    Assisted Solution

    or 0:40:00 works as well.
    LVL 24

    Expert Comment


    as 1 = 1 day then 1 min = (1 / 24) / 60 or 1 / 1440
    so 40min =  40 / 1440

    so 9:30 + (40 / 1440) will do it.
    LVL 50

    Expert Comment

    by:barry houdini
    Another way is to add a time value in quotes, to add 40 minutes to A1


    regards, barry
    LVL 9

    Expert Comment

    by:Evan Cutler
    Sorry, I just wanted to point out the DateAdd function does work for minutes and seconds, if the cells are set to Date format.

    DateAdd("n", 5, field)  </-- adds five minutes-->

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now