Hello
A while back, people were very helpful in helping retrieve start and finish times from a rota system i have built (See Here).
I need to do something similar again and the formulas I used then don't work because I am not doing things the same way. What I'm after is it to retrieve the start and finish time based on the filled bar by each name. It currently auto fills depending on a drop down list (thanks Pete_UK), but in some cases there will be times where the shift required needs to be manually entered. This is done by entering a '1' which then makes the bar go black, later on down the line it will use this information in other ways.
In the sheet are two tabs. the first is a blank one, and the second 'What I would like' has the two columns highlighted with what I would like to be able to see. I assume it can be done using 'Small' and 'Large' but I'm not sure how to do that based on two separate lines.
If anyone can help that would be great.
Suede
Bookmarks