how to convert whole numbers representing seconds to mm:ss

Elvin · Mar 5, 2006

how can i convert in excel whole numbers (ex 234) representing seconds to mm:ss

Guest · Mar 5, 2006

Hi

Divide it by 1440 and format as time.

Andy.

via135 · Mar 6, 2006

hi!

try this!!

=TEXT(A1/86400,"mm:ss")

assuming your number is in A1

-via135