Hi,
I have a spreadsheet where I have taken dates, times, customer names, employee names and generated a calendar. It is almost done, but there is one bit I cannot crack. The calendar is broken down into 15m sections, so a 1hr appointment should have 4 boxes shaded in with the text "1hr Mr Smith"

So far, I can do this by deleting the content of the 3 cells after the one with the text - hope you can see this from the example I have posted.

I am using Excel 2003.

Unfortunatley I can't attach excel, but I can attach a screen shot of the calendar.

What I am looking for is a formulae that can allow the text to be shown over 4 shaded boxes for 1hr, and for 8 shaded boxes for 2hrs etc (as per the THURSDAY example on the attachment)