Hi there,

My spreadsheet tracks and measures the performance of tasks. In Column B, I
have a list of start times in the time format hh:mm in two other columns I
have the total time for that work session (Column D) and the output in units
in (Column M), I am after a formula that will show the average hourly output
for work beginning in each of the 24 hours of a day, it doesn't matter how
long the work sessions are. I want to compare the output in an hourly rate
for people starting work at various times in the day, to gauge when the most
productive time to start is.

The results would be in a column with twenty four cells 0h to 24h and the
average hourly output for based on when the person started in the day, eg 3am
or 7pm etc. Any help would be fantastic, thank you

--
thanks