Hi there,

I would like to create a sheet for a staff schedule. I have one sheet that uses COUNTIF to find out when a staff member is working.

For every hour the staff member works (7am, 8am, 9am) a letter indicates where they work. COUNTIF tells me how many hours they work. 8am until 4pm. 8 hours.

Is it possible to send some information from this sheet to another that basically says a start and finish time for a particular staff member? This sheet would be viewed by staff as their roster/ schedule.

Thanks in advance