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 |
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.
https://docs.google.com/
----------------------------------------------------------------------------------
No comments:
Post a Comment