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