Time Fromulas

[Abdul]

I have a sheet in which one column is for "Actual Time", i have to allo
the time band wise (which is one hour) %age to Actual time column.

How can i allot it with formula or macro?

Data Sample is:

Time Band %age
89%
100%
100%
100%
NA
NA
NA
100%
100%
-72%
100%
12%
100%
-66%
100%
33%
100%
100%
81%
57%
50%
100%
48%
94%

Time Band for 24 Hrs
0:59:00
1:59:00
2:59:00
3:59:00
4:59:00
5:59:00
6:59:00
7:59:00
8:59:00
9:59:00
10:59:00
11:59:00
12:59:00
13:59:00
14:59:00
15:59:00
16:59:00
17:59:00
18:59:00
19:59:00
20:59:00
21:59:00
22:59:00
23:59:00



Actual
Time
0:30:00
9:00:00
11:00:00
13:00:00
13:30:00
14:30:0