How to Insert Result of SUM from Two Date in the spreadsheet
Data:
- H3:
27/11/2013 1:31:00
- F3:
00:15
- I3: Should be appear the result of SUM (H3+F3) using this formula
=SUM(H3+F3)
. The Result is27/11/2013 1:49:00
(24hs Formatting)
Action:
- Should be executed only when some insert a value in the column F starting 3rd row.
- Only should be executed for the row where was modify.
- Should be insert the result in column I, the sum of H+F
Here I have the starting script for the 1 & 2.
function CreationDate(event){
//Script Sume Date
var actSht = event.source.getActiveSheet();
if (actSht.getName() == "sheet1"){
var activeCell = actSht.getActiveCell(); //Detec the ActiveCell
var column = activeCell.getColumn(); // Detect the Column of the ActiveCell
var colNums = [6]; //Coulmns, whose edit is considered
if(colNums.indexOf(column) == -1) return; //If column other than considered then return
var row = activeCell.getRow(); //Detect the ActiveRow
if(row < 3) return; //If header row then return
TEST:
I try to formatting this script Clic Here to sum the data and back the result in dd/mm/yyyy hh:mm:ss but I didn't have lucky.
Why is needed?:
Is very important have this formula run asap because I use is to scheduling a critical call to many ISP around the country.
I try to use =arrayformula(sum(h3+f3))
but didn't work. I needs a script because I add new rows all the time.
I will appreciate your help.
Best Regards,