Help with employee scheduling

[DFournier]

I am rewriting this post hopefully to make it clearer...

I have created an employe schedule using excel

Breakfast runs from 6 am to 10:30 am

Lunch runs from 10:30 am to 2pm.

Joe is scheduled from 6am to 2pm and he makes 7.00 per hour.
Lisa is scheduled from 7am to 1pm

Breakfast sales were $300

Lunch sales were $700

Here is what I want to do...

I want to create a line for Breakfast sales and labor and then Lunch sales and labor.

How do I tell excel to extract hours between 6am and 10:30 am for the breakfast sales cell and extract hours for the lunch cells?

[daddylonglegs]

Hell Dfournier,

It's against forum rules to "crosspost" at another forum without a link. Please take some time to read the rules, thank you

Crossposted here