Wednesday, April 24, 2013

yogi_Given Start Time End Time And Number of Tasks Compute Number Of Tasks Per Hour Row By Row


                                          Google Spreadsheet   Post  #1151
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 24, 2013
user rjcb3 :(http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/AlzOG2s3PSY)
Hello,

I would like to be able to calculate numbers into time:  for example:  I already have a formula to calculate =now() as a start time and then manually enter an end time of the day...let's say now until 20:00 (8:PM) and so, it's easy enough to see how many hours are available.

What I would like to do is to include a number of activities to divide up into that time.  So, let's say 20:00:00 - =now() equals a time of 4:23 (four hours and 23 minutes)  How could I enter in [say] 20 tasks and have it calculate (divide) how many tasks per hour?  (which should be five and some change)

I've already tried time/tasks and that, does not work because that's calculating between two formats.  I tried formatting the time as a number and doing it that way, but, it came out with a string of negative numbers that didn't work either.

Please help.
--------------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem