I am designing a schedule from a roster. I have start time, end time and
duration of shift.
I would like a formula to recognise the start time and end time and allocate
the value of 1 or fraction of one hour to a cell(s) so that I can visualize
coverage over the shift.
I have set up a sheet with Name Start time end time and duration of shift.
adjacent to this I have time periods in AM and PM, e.g 5-6, 6-7, 7-8,I want
a formula to recognize and the start time (or part their of ) and give a
value of 1 against the name of the staff member, if the staff doesn't start
until 10am then the cell has a nill value.
This is driving me nuts, any help would be much appreciated.