How do you add based on base 60 (minutes) instead of 100
 

Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
minutes

Enter it in time format, 5:32

Make sure that the total cell is formatted as [hh]:mm to cater for more than
24 hours.

--
HTH

Bob Phillips

"Mick Stohr" <Mick wrote in message
...
Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
minutes

=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

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

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?