Hi all,<o
></o
>
<o
> </o
>
I am a novice at excel and not sure if its possible formy idea to work.<o
></o
>
<o
> </o
>
I want to create a sheet which tells me the total numberof staff I have on duty during the day. With times every half hour from 0700 to2230. <o
></o
>
When I put what time each staff member is working, I simplywant to see the cell row turn a solid colour.<o
></o
>
<o
> </o
>
The idea is to see how many staff members are in duringthe day.<o
></o
>
<o
> </o
>
I hope this makes sense and I appreciate any help given.
i.e
0700 0930
0800 1000
0900 1000
[TABLE="width: 100, align: left"]
<tbody>[TR]
[TD]0700[/TD]
[TD]0730[/TD]
[TD]0800[/TD]
[TD]0830[/TD]
[TD]0900[/TD]
[TD]0930[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[/TR]
</tbody>[/TABLE]


<o


I am a novice at excel and not sure if its possible formy idea to work.<o


<o


I want to create a sheet which tells me the total numberof staff I have on duty during the day. With times every half hour from 0700 to2230. <o


When I put what time each staff member is working, I simplywant to see the cell row turn a solid colour.<o


<o


The idea is to see how many staff members are in duringthe day.<o


<o


I hope this makes sense and I appreciate any help given.
i.e
0700 0930
0800 1000
0900 1000
[TABLE="width: 100, align: left"]
<tbody>[TR]
[TD]0700[/TD]
[TD]0730[/TD]
[TD]0800[/TD]
[TD]0830[/TD]
[TD]0900[/TD]
[TD]0930[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]in[/TD]
[TD]in[/TD]
[TD]in[/TD]
[/TR]
</tbody>[/TABLE]