Friday, November 9, 2012

yogi_Compute End Time By Adding Minutes From Description To Start Time


                                           Google Spreadsheet   Post  #863
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 09, 2012
user lizz3 said : (http://productforums.google.com/forum/?zx=sa5238gcjnz7#!topicsearchin/docs/time$20in$20minutes/docs/yZPFTSm3pPU)
calculate maximum time from one column with total minutes, one column with start time
Hello!  I would like to be able to have one column in which the maximum time in minutes is entered and one column in which a starting time is entered.  I would like the maximum time in minutes to be added to the start time to produce a column with what the ending time should be.  For example, Column A, 30 minutes.  Column B, 12:15:00, and Column C (Column A + B = ) 12:45:00.

Please help me!

Thanks so much!

-----------------------------------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment