Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
Hi again!!! I've received excellent help on how to return values I need! Here is the resulting spreadsheet!
Now, is it possible to have the range I input into cells AB7 and AB8 turn a color? Say yellow so it is apparent what time range you are looking at??
I know...I'm so demanding!!!
Thanks for all of your help!!
Dave M.
November Forced Disconnects.xls | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |||
1 | 11/18/02 | 11/19/02 | 11/20/02 | 11/21/02 | 11/22/02 | 11/25/02 | 11/26/02 | 11/27/02 | 11/28/02 | 11/29/02 | ||||||||
2 | 1 | 1 | 2 | 1 | 0:00 | InHours: | 4 | |||||||||||
3 | 1 | 0:30 | ||||||||||||||||
4 | 1 | 1 | 2 | 1:00 | OutofHours: | 10 | ||||||||||||
5 | 2 | 2 | 1:30 | |||||||||||||||
6 | 2:00 | |||||||||||||||||
7 | 2:30 | StartTime: | 0:30 | |||||||||||||||
8 | 3:00 | EndTime: | 1:00 | |||||||||||||||
TRAC |
Now, is it possible to have the range I input into cells AB7 and AB8 turn a color? Say yellow so it is apparent what time range you are looking at??
I know...I'm so demanding!!!
Thanks for all of your help!!
Dave M.