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.