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