fx shows correct value but not cell
 

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.

fx shows correct value but not cell
 

=(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.