Re: [Skate] Excel errors.

Den 15. mar. 2018 kl. 22.57 skreiv Steinar Vissebråten  
[email protected] [Speed_skating]:
> Why does my calculation in excel like this return an error like this:
> =IF(Q2="";"";(IF(LEN(Q2)=5;Q2;LEFT(Q2;2)*60+MID(Q2;3;2)&","&RIGHT 
> (Q2;2)))/3)
>


It does seem to me like the system converted from text to number  
automatically before, but now you have to do it manually. Because the  
results of the LEFT, MID and RIGHT functions are text strings. Maybe  
you should run them through a function converting from string to  
number before you multiply by 60 or divide by 3.

LEF

....from Redal, where I´m writing on my old 2006 iBook because my old  
2012 MacBook Pro has crashed, only half backed up...

------------------------------------
Posted by: Lars Finsen <[email protected]>
------------------------------------