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
No comments:
Post a Comment