Calculate Pick Rate for team of pickers

[Callumlenehan]

Hi , could someone please design me a simple Excel on calculating Pick Rates, I get given the number of items picked for each picker daily:

START TIME - 0730
END TIME -1630
LUNCH BREAK- 1 Hour
Number of Items Picked Today =

Thank you

[Bob Phillips]

Try

=items_picked/((finish_time-start_time-break)*24)