| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
The "--" (double unary minus) will coerce the text to numbers/times, so
if you included them, SUBSTITUTE() returning Text is not the problem. In article , "Mick Stohr" wrote: Must have done something wrong. get error message. The subsititute command seems to give text back so it can't be summed. Dont understand the arrray part. Would prefer using the period since its easier (so i am lazy-efficient). Would you elaborate? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding cells based on condition | Excel Worksheet Functions | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
Threaded Mode
