Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Excel - computing Hours and minutes question

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
brothertruffle880
Asked:
brothertruffle880
2 Solutions
 
Ken ButtersCommented:
http://www.exceldigest.com/myblog/2009/02/12/add-hours-or-minutes-to-a-standard-time/



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

so to add 40 minutes....

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

.... or "9:30" could reference cell A1 for example... if cell A1 had 9:30 in it.
0
 
Evan CutlerVolunteer Chief Information OfficerCommented:
What's the cell formatted?  Date?

if Date, and time is included with date:

http://www.techonthenet.com/excel/formulas/dateadd.php

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

Cheers.
0
 
Ken ButtersCommented:
supposing cell a1 had 9:30 in it...

you could use the following formula : =A1+time(,0,40,0)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ScriptAddictCommented:
or 0:40:00 works as well.
0
 
SteveCommented:
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
 
barry houdiniCommented:
Another way is to add a time value in quotes, to add 40 minutes to A1

=A1+"0:40"

regards, barry
0
 
Evan CutlerVolunteer Chief Information OfficerCommented:
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-->
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now