I have a spreadsheet for working out a working shift rota. I want for instance if i have a name in cell a4, the in cell b4 have the words "3-10" I then want on a seperate sheet in the same work book the number 7 to represent 7 worked hours, then on cell c4 "2-20" to represent 8, then totalling up on sheet to the hours for that person, any ideas?
Thanks
Jim
Bookmarks