| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| cell shows 0 when referenced cell is null | Excel Worksheet Functions | |||
Threaded Mode
