I have a base time of 10:30 AM set in a cell. I am entering the number of minutes, e.g. 4, in a different cell.
How can I add the minutes from the second cell to the first in order to display a new time?
Google-sheets – Adding minutes to base time
google sheets
Related Solutions
Adding a column for date and calculating the C values with:
=if(istext(D1),C2,D1+C2)
in D2 copied down a chart might be plotted of this Data Sheet1!A1:A4, Sheet1!D1:D4 with Use row 1 as headers:
You should be able to do that quite easy with a summation (do use colons (:) in the notation):
A1=00:13:45A2=00:05:12
Then use SUM formula:
SUM(A1:A2)
The result will be: 00:18:57
UPDATE 18-01-2013
See example file I´ve created: Google Spreadsheets: Counting minutes/seconds
If you use Neo's formula, to get rid of the points, in combination with an ARRAYFORMULA you will get the result as well:
=ARRAYFORMULA(SUM(TIME(LEFT(B2:B3,2), MID(B2:B3,4,2), RIGHT(B2:B3,2))))
See example file (+1 for Neo)
Related Topic
- Google Sheets – Calculate Time Values in a Single Cell
- Google-sheets – How to duplicate two cells from a column to rows in a particular order
- Google Sheets – Add Up Time Used in Minutes for Spreadsheet or Doc Table
- Google-sheets – Entering mm:ss: milliseconds into Google Sheets for time duration (arithmetic)
- Google Sheets – Using Alpha-Numeric Time Representation in a Formula
- Google-sheets – How to calculate a time in the future by adding a certain amount of time periods to a base time
- Google Sheets – How to Show Hours Over 24
Best Answer
Your question is if you have a time-value stored in a cell, and and integer value stored in another cell representing minutes, in a third cell (cell-three) how do I add the minutes represented by the integer in cell-two to the time-value in cell-one?
To do this you need to understand date value. Date values, even though they display for instance 9/26/2016, they are actually stored as an integer 42639 whose units are days, where day zero is 12/30/1899.
Time-values are also stored as days. This means that 10:30am is really 10.5÷24 days.
If you want to add 4 minutes to the time-value you'll have to make sure that it is also converted to day-units. So 4 minutes = 4÷24÷60 days.
If cell A4 is what you are calling "Base Time" & cell A5 is the cell you wish to add minutes to, then you can accomplish this by the formula
=$A4+$B5/24/60