Hi

This formula assume that total time in column D is not entered as Time, but
as a regular number. Column N is the start time to calculate average for.

=SUMIF($B$2:$B$5,N3,$M$2:$M$5)/SUMIF($B$2:$B$5,N3,$D$2:$D$5)

Regards,
Per

"Morgan" skrev i meddelelsen
...
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