This is a discussion on Re: kspread parse error - KDE ; Geoff Sullivan wrote: > What I really want is 2:05. > You will get that if you put the value in A1 and then for B1 C1 and D1 use =FIXED(INT(A1/60);0) and =FIXED(MOD(A1;60);0) =CONCATENATE(B1;":";C1) Like always there are many ways ...
Geoff Sullivan wrote:
> What I really want is 2:05.
>
You will get that if you put the value in A1 and then for B1 C1 and D1 use
=FIXED(INT(A1/60);0) and =FIXED(MOD(A1;60);0)
=CONCATENATE(B1;":";C1)
Like always there are many ways to kill a koala in a spreadsheet:-)
--
regards,
andrew
