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.

Attached Files

Sample Timesheet.xlsx (25.1 KB, 19 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]