Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average outage time?
I have a sheet that shows when an item was logged out (i.e. maintenence) and
when it was logged back in. The sheet calculates how long each item was logged out. Now I want to calculate the average outage time for all items listed. I have tried the following functions, the first one errors becase of zero values, the second one is supposed to ignore zero values, but it just doesn't work. =AVERAGE(J114:J164) =AVERAGE(J114:J164)+IF(J114:J164<0,"","") Anything will help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) |