Assign a relative value from a cyclic range?

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Ok, i have a very specific and (i assume) fairly complex question:

In one sheet i have a data range of 18 time stamps (numeric value of minutes)

Ie:
F10 12
F11 13
F12 16
..//..
F18 12

In Cell B4 (of current sheet)i have the starting time
Ie:
B4 09:00

In Cell B5 (of current sheet)i have the start position (1-18) of that group, that represents
the positions of the data range in the other sheet (above)

What i do in current sheet is to show a relative timetable

With this formula in a colume (1-18)
=B4+TIME(0;Banan!F10;0)
=B4+TIME(0;(Banan!F10+Banan!F11);0)
=B4+TIME(0;(Banan!F10+Banan!F11+Banan!F12);0)
etc....

This ONLY works if i start on position 1 in the referalsheet (F10)

What i want to be done is to use ther current sheets B5 value to set
starting point in the data range and then cycle through all the cells.


Ie (This does obviusly not work... ):
=B4+TIME(0;Banan!)(x+b5));0)
=B4+TIME(0;(Banan!(x+b5)+Banan!(y+b5);0)
=B4+TIME(0;(Banan!(x+b5+Banan!(y+b5)+Banan!(z+b5);0)

Etc. so that if the cycle starts at the referal sheets F14 it should end at F13


Finally the question:

How do i acomplish that?


//Micael Magnusson

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
0