Hello again all,
I'm WAY over my head on this, but... I am trying to calc the average age of
a issue ticket. Open column C is the SEVERITY LEVEL. Open column D is the
time created, example 10/09/2006 10:16:47.

This formula works (in Excel it has { } around it.

=(NOW()-(SUMIF(Open!C1:C983,B16,Open!D1:D983)/COUNTIF(Open!C1:C983,B16)))*24

I am trying to replace NOW() with Cell C1. C1 is a static date and time,
example 10/10/06 10:40 AM

I have this formula, but it returns values that are WAY off. Thoughts?