Thursday, June 18, 2015

yogi_Compute Times For Specified Number Of Tasks Given Start Time And Number Of Tasks Per Hour


                                           Google Spreadsheet   Post  #1967
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jun 18, 2015
question  by TN Dispatch:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/vEoANsedz5g
Schedule Builder
Hello i am looking for a formula that will build be a schedule based on a start time and number of trucks per hr
so if the start time is 14:30 and i need 1 trk every 4 hours then i will get a schedule that looks like this
14:30
18:30
22:30
02:30
06:30
now if the current time hits 18:30 i want to see
18:30
22:30
02:30
06:30
10:30
say i change the trks per hr to 4 trks every hr and the schedule starts at 14:30 the schedule will look like this
14:30
14:45
15:00
15:15
15:30
and when 14:45 comes around it will show
14:45
15:00
15:15
15:30
15:45
when 15:00 comes around it will show
15:00
15:15
15:30
15:45
16:00
and so on i have attatched the spreadsheet and highlited in yellow where i want the values to appear and in green is where i will put the start time and trks per hr.

----------------------------------------------------------------------------------