Convert seconds to minutes and seconds in excel

=?Utf-8?B?YW5vbnltb3Vz?=
Guest
Posts: n/a

 25th Dec 2004
I need a formula which converts seconds to minutes and seconds.

TY for your help. Happy Holidays.

Chris

Ragdyer
Guest
Posts: n/a

 25th Dec 2004
This is for display only:
With seconds in A1:

=INT(A1/60)&" Min "&MOD(A1,60)&" Sec"
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"anonymous" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I need a formula which converts seconds to minutes and seconds.
>
> TY for your help. Happy Holidays.
>
> Chris

JE McGimpsey
Guest
Posts: n/a

 25th Dec 2004
XL stores times as fractional days, so to convert integer seconds to an
XL time (minutes and seconds), divide by 24*60*60:

A1: 123
A2: =A1/86400

which will display 2:03 when formatted as [m]:ss

In article <(E-Mail Removed)>,
anonymous <(E-Mail Removed)> wrote:

> I need a formula which converts seconds to minutes and seconds.
>

Guest
Posts: n/a

 25th Dec 2004
=A1/86400

Custom time format the formula cell as:

[mm]:ss

"anonymous" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I need a formula which converts seconds to minutes and seconds.
>
> TY for your help. Happy Holidays.
>
> Chris

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Cliff Microsoft Excel Worksheet Functions 2 18th Jun 2009 05:10 AM Al Microsoft Excel Misc 1 11th Mar 2009 10:04 AM rachel Microsoft Word Document Management 2 18th Mar 2008 01:07 PM tshad Microsoft ASP .NET 7 12th Mar 2005 12:27 AM =?Utf-8?B?QnJpYW4=?= Microsoft Excel Worksheet Functions 2 9th Dec 2004 10:45 PM

Features