| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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? "N Harkawat" wrote: =SUM(--SUBSTITUTE(IF(A2:A100<"",A2:A100&".0","0.0"),".", ":"))*24 array entered (ctrl+shift+enter) and assuming there is no text in the range "Mick Stohr" <Mick wrote in message ... Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32 minutes |
| 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
