Assign a relative value from a cyclic range?

Closed
doodle - May 9, 2010 at 04:27 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 9, 2010 at 06:10 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 9, 2010 at 06:10 AM
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