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> </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]