[OpenTRV-dev] google spreadsheet

[Bo Herrmannsen]

seems it does not simply split but also adds the delimiter to the result

102:47:00.000

my initial thought is simple rude: WTF.... cant you just do as told....
)(/&%¤#¤


2014-09-06 11:54 GMT+02:00 Bo Herrmannsen <EMAIL ADDRESS HIDDEN>:

> So i got the serial output in to a spreadsheet...
>
> want to split it up right so its more usefull
>
> raw data: Energy: 102.47
>
>
> formula: =split(A1; ":"; False)
>
> *result: *102.47.00
>
> have tried to set the format of the result cell to automatic, text,
> numbers....
>
> no matter what it added .00
>
> what am i doing wrong?
>
> --
>
>                  |||||
>                @(~Ô^Ô~)@
> -------------oOo---U---oOo-------------
> |                                     |
> |  Bo Herrmannsen                     |
> |                                     |
> |                                     |
> | "blessed are the "cracked",         |
> |  for its they who let in the light" |
> |                         Ooo         |
> |_________________ooO____(   )________|
>                  (   )    ) /
>                   \ (    (_/
>                    \_)
>
>
>
>


-- 

                 |||||
               @(~Ô^Ô~)@
-------------oOo---U---oOo-------------
|                                     |
|  Bo Herrmannsen                     |
|                                     |
|                                     |
| "blessed are the "cracked",         |
|  for its they who let in the light" |
|                         Ooo         |
|_________________ooO____(   )________|
                 (   )    ) /
                  \ (    (_/
                   \_)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/8021776b/attachment-0001.html>