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)
Like always there are many ways to kill a koala in a spreadsheet:-)