I have been considering myself as an excel expert.. only till i came across this problem..
I have been working on the Network Availability of Cell Towers, while i have ways to calculate the overall Network Availability of the tower. i now want to know the hourly network availability in each city.
Data Source has
Start Time of Fault & End Time of Fault.
So if a Cell Tower is Down from Say 0:10 Hrs to 06:10 Hrs the excel formula should have 50 minutes in Hour 1, 60 Mins in Hour 2,3,4,5 and 10 mins in Hour 6.
Sample data pasted below...
<colgroup><col><col span="2"><col span="6"></colgroup><tbody>
</tbody>
Help will be appreciated...
I have been working on the Network Availability of Cell Towers, while i have ways to calculate the overall Network Availability of the tower. i now want to know the hourly network availability in each city.
Data Source has
Start Time of Fault & End Time of Fault.
So if a Cell Tower is Down from Say 0:10 Hrs to 06:10 Hrs the excel formula should have 50 minutes in Hour 1, 60 Mins in Hour 2,3,4,5 and 10 mins in Hour 6.
Sample data pasted below...
EventStartDate | StartTime | EndTime | Hour 1 | Hour 2 | Hour 3 | Hour 4 | Hour 5 | Hour 6 |
11/1/2013 | 0:00 | 0:15 | 15 | - | - | - | - | - |
11/1/2013 | 0:00 | 0:20 | 20 | - | - | - | - | - |
11/1/2013 | 0:00 | 0:22 | 22 | - | - | - | - | - |
11/1/2013 | 0:00 | 0:34 | 34 | - | - | - | - | - |
11/1/2013 | 0:00 | 1:15 | 60 | 15 | - | - | - | - |
11/1/2013 | 0:00 | 5:14 | 60 | 60 | 60 | 60 | 60 | 14 |
<colgroup><col><col span="2"><col span="6"></colgroup><tbody>
</tbody>
Help will be appreciated...