Solved

Excel - computing Hours and minutes question

Posted on 2012-08-20
381 Views
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.
0
Question by:brothertruffle880

LVL 19

Expert Comment

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

="9:30"+TIME(0,40,0)

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

LVL 9

Expert Comment

What's the cell formatted?  Date?

if Date, and time is included with date:

Cheers.
0

LVL 19

Accepted Solution

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

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

LVL 11

Assisted Solution

or 0:40:00 works as well.
0

LVL 24

Expert Comment

or...

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.
0

LVL 50

Expert Comment

Another way is to add a time value in quotes, to add 40 minutes to A1

=A1+"0:40"

regards, barry
0

LVL 9

Expert Comment

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

0

Featured Post

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.