Hi,

I am trying to build a spreadsheet to show data from scheduled jobs. I have attached a sample spreadsheet. The main data I want to capture is the amount of hours on a certain day. In some cases or most, the job will spread over a period of time so the bid hours might have to calculate to multiple days. Here is my example and I hope someone can help or let me know this is not possible.

Thank you,

Smirk
jeremyworksheet.xlsx