Forum Discussion
Text to numerical value
Hello all,
I need to start by saying I am an absolute dinosaur, so don't really understand the coding language used, which I think is where I am going wrong as I don't understand it!
I have created a timetable sheet. I have 4 teams and 5 possible shifts to select.
The table auto calculates from the master box at the top and adjusts all the related shifts for all the teams.
It colour codes and calculates the pattern and hours fine, but would love it if from the drop down list on the cells, if it showed in the LIST, the names of the shifts, Earlies, Lates, etc, but appeared in the cells as the shift times (showed numerical value 0700-1600) and I am being bamboozled by the terminology.
Can anyone help please?
You better edit that screen-shot, it seems to contain personal information
Thank you.
I edited it, but it seemed to have uploaded original file.
Told you I was a dinosaur!
