| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Can't remember which sheet I took that example from but details for one of
the sheets are as follows :- C89 = 5:30:00 a.m. which displays as 5:30 because of the [h]:mm D89 = 6:51:00 a.m. which displays as 6:51 E89 = =IF(C89 <"",IF(D89 <"",+D89-C89,"no finish time"),""), which gives a result if I F2, F9 of 0.05625 but displays as 0:00 I've tried reformatting and recalcing E89 in various ways, but all give a display of 0 in various forms. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| In Excel 2003, the histograms are incorrect. Excel shows a bar gr. | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
| How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
