M
Mick Stohr
Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
minutes
minutes
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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.
Make sure that the total cell is formatted as [hh]:mm to cater for more than
24 hours.
N
N Harkawat
=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
array entered (ctrl+shift+enter)
and assuming there is no text in the range
M
Mick Stohr
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?
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?
J
JE McGimpsey
The "--" (double unary minus) will coerce the text to numbers/times, so
if you included them, SUBSTITUTE() returning Text is not the problem.
if you included them, SUBSTITUTE() returning Text is not the problem.