|re: "Using formula =INT(A1)/60)&":"&MOD(A1,60)"|
I doubt it, since that formula won't work.
Excel won't even accept it because you have an extra parenthesis in it.
Either the ) after the first 60 has to be removed or the ) after the first A1 has to be removed.
Depending on which ) you remove, you'll get different results, so there's no sense in us trying to help until you tell us what formula you are really using.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.