what is the formula to convert 5513 seconds into minutes 00:00:00

[Bob Phillips]

=A20/86400

and format as time

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[David Biddulph]

[nothing except the subject line]

=A1/(24*3600) and format the result as time.

 

[Stephen Bye]

You can do:
=TIME(0,0,5513)
and format the cell as [mm]