Sorry,
It may be helpful to put the values I am getting, and formula's i'm using.

Column D has only one value, and it is 10/09/2006 10:16:47
Cell C1 has the value of 10/10/06 10:40 AM

The value returned from formula

=((C1)-(SUMIF(Open!C1:C816,B16,Open!D1:D816)/COUNTIF(Open!C1:C816,B16)))*24

is
936010.6667


The value returned from formula
=(NOW()-(SUMIF(Open!C1:C983,B16,Open!D1:D983)/COUNTIF(Open!C1:C983,B16)))*24

is
26.51808889



"David" wrote:

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?