Hello All
New to the board and mostly new to excel. :/
I've found many ways to calculate up time and down time. What my problem is that I need to track these over a peroid of a year in 1 month chunks.
What Ive got so far is;
Colums A & B contain unit Stop and Start Date & time
Ex: 11/2/2010 8:30
Column C subtracts A & B and is formatted Custom [h]:mm
No problems here.
Colum D my Uptime/Availability formula
=(Config!$N$5-(N4*24))/Config!$N$5*100
Where N5 = "=DAY(DATE(YEAR(M2),MONTH(M2)+1,0))*24"
[All of this by the way gleened from various sources on the internet.]
What this does is give me tracking for down time per row and the uptime.
But what it does is change the month each month which is what I wanted to start with. Now what I've been tasked with is to track each month over a year.
Can this be done with what I've got all on one sheet?
New to the board and mostly new to excel. :/
I've found many ways to calculate up time and down time. What my problem is that I need to track these over a peroid of a year in 1 month chunks.
What Ive got so far is;
Colums A & B contain unit Stop and Start Date & time
Ex: 11/2/2010 8:30
Column C subtracts A & B and is formatted Custom [h]:mm
No problems here.
Colum D my Uptime/Availability formula
=(Config!$N$5-(N4*24))/Config!$N$5*100
Where N5 = "=DAY(DATE(YEAR(M2),MONTH(M2)+1,0))*24"
[All of this by the way gleened from various sources on the internet.]
What this does is give me tracking for down time per row and the uptime.
But what it does is change the month each month which is what I wanted to start with. Now what I've been tasked with is to track each month over a year.
Can this be done with what I've got all on one sheet?