I don't know if it can be done with a format. If you use this formula, it can format it as text (assumes the seconds are in A1)
=TEXT(A1/60, "00")&":"&TEXT(MOD(A1,60), "00")
I don't know if it can be done with a format. If you use this formula, it can format it as text (assumes the seconds are in A1)
=TEXT(A1/60, "00")&":"&TEXT(MOD(A1,60), "00")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks