2003 or 2007?
I hope I understand what you are getting at. Could you not make b1 a cell
that is headed 00:00 - 06:30. C1 6:30 - 6:45 etc so that the cells become a
block of time. Down col A I think you have names.
Once all names and time zones established set conditional formatting so that
- say - N = Not working (fill and text colour red), W = working (Fill & text
green), B = break (blue)
So now all you do is input w for when John is working 00:00 - 06:30 etc
Let me know how it goes or get back if I'm on the wrong track.


"clark-ee" wrote:

Is there a way to fill in multiple cells based on a block entry of time.

eg.
A B C D E F
00:00 06:30 06:30 06:45 06:45 08:45
09:00 13:30 08:45 09:00 13:30 16:00
16:15 24:00 16:00 16:15

Not working Breaks Working

This would represent a 24 hour period. In most cases, there would be as
many as 12 entries per column.

I have set up a sheet already that has the information layed out in rows, I
want to be able to easily enter the time information, and then fill in the
correct information based on the 3 criteria listed above.