Check my website for the "Hours affected by Dates" example.
It'll return how much running time a given hour had. Then you could multiply
that by Items per Hour.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jan" wrote in message
...
Hi to all
This is my basic spreadsheet
C1 Production Start time
C2 Produstion Stop time
C3 Run time (C2-C1)
C4 Items per Hour
C5 Total production (C3*C4)
C6-C29 (24 hours of the day) I would like the items produced that hour
based on start time and stop time. What formula would work for me?
Thank you so very much!
Jan