fx shows correct value but not cell

[David]

Hello,
This is somewhat of a repost from here
http://msdn.microsoft.com/newsgroup...696c&mid=0bbda325-f240-4478-9724-167609028fd7

I have this formula.

=(C1-AVERAGE(IF(open!C1:C983=B16,open!D1983)))*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.

 

[Max]

=(C1-AVERAGE(IF(open!C1:C983=B16,open!D1983)))*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.