C
Craig
I need a formual that will give me a reult when I enter in the date and
hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
would like a formula in cell A3 to return a value of 56. Is this possible?
Thanks for any help.
Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
0 1 25 49 73 97 121 145 169 193 217 241 265
1 2 26 50 74 98 122 146 170 194 218 242 266
2 3 27 51 75 99 123 147 171 195 219 243 267
3 4 28 52 76 100 124 148 172 196 220 244 268
4 5 29 53 77 101 125 149 173 197 221 245 269
5 6 30 54 78 102 126 150 174 198 222 246 270
6 7 31 55 79 103 127 151 175 199 223 247 271
7 8 32 56 80 104 128 152 176 200 224 248 272
hour. For instance if I enter date=3 in cell A1 and hour=7 in cell A2, I
would like a formula in cell A3 to return a value of 56. Is this possible?
Thanks for any help.
Date/ Hour 1 2 3 4 5 6 7 8 9 10 11 12
0 1 25 49 73 97 121 145 169 193 217 241 265
1 2 26 50 74 98 122 146 170 194 218 242 266
2 3 27 51 75 99 123 147 171 195 219 243 267
3 4 28 52 76 100 124 148 172 196 220 244 268
4 5 29 53 77 101 125 149 173 197 221 245 269
5 6 30 54 78 102 126 150 174 198 222 246 270
6 7 31 55 79 103 127 151 175 199 223 247 271
7 8 32 56 80 104 128 152 176 200 224 248 272