Hi aulrich,
This is possible with formulae, but they're quite complex. To complicate things, your data appear to have some errors on the Calendar sheet:
• D8 is empty
• on row 6, you appear to have start & end times of 8AM & 12AM, respectively, on the same date - either the end time should be 12PM (for a noon finish) or the date should be the next day (for a midnight finish).
The attached workbook has the formulae filled in for the first day - just to give you an idea of the complexity. Correct the above errors and you'll get some meaningful output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|