=(C1-AVERAGE(IF(open!C1:C983=B16,open!D1:D983)))*24

The formula is an array formula which needs to be *array-entered*. To
array-enter a formula: Click inside the formula bar, then press
CTRL+SHIFT+ENTER (instead of just pressing ENTER)

Done correctly you'd see Excel wrap curly braces { } around the formula in
the formula bar.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David" wrote in message
...
Hello,
This is somewhat of a repost from here
http://msdn.microsoft.com/newsgroups...4-167609028fd7

I have this formula.

=(C1-AVERAGE(IF(open!C1:C983=B16,open!D1:D983)))*24

The displayed value is 936017.0

When I click on fx next to tool bar, a dialog box titled function Argument
appears. In this dialog box, it says Formul result = 1.1 hours. Why can I
not get it to display 1.1 hours like is displayed in the functional
argument
dialog box? 1.1 hours is the correct value.

Any assistance you can provide would be appreciated.