Need a formula that works out hours staff worked and if meals required

I am trying to devise a spreadsheet that will help me with my work.

I occasionally have to manage a large number of staff over a short number of days and need to provide accreditation/ passes for them all and also catering on the days they work so need to have a total number of passes needed for each day and a total number of meals - breakfast, lunch & dinner each day

I usually have two separate spreadsheets - one for passes and one for catering where under each day I add a '1' by a persons name for each day they are in on the passes list and then on my catering chart I manually add a '1' by each meal per day.

But I would love to find a way where I can combine the two simply and where a formula would work to automatically fill in what meals they need if I specify that they need a pass for a particular day and they hours that they will be working?

I have started a spreadsheet where I list date, the start & finish time for each individual on that particular day and then further columns which list breakfast, lunch & dinner for each day and want the formula to be able to work out if they are working when meals are served. I have tried playing around with the IF function but it doesn't seem to work well - or at least I am not using it well and would love if someone could give me some advice on how to make it work? I hope this makes sense?!

Any help greatfully received

Welcome to the forum, magda.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.