PC Review


Reply
Thread Tools Rating: Thread Rating: 5 votes, 3.40 average.

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
 
Reply With Quote
 
 
 
 
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


 
Reply With Quote
 
 
 
 
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.
>

 
Reply With Quote
 
Aladin Akyurek
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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to convert Minutes:Seconds format to minutes with seconds con Cliff Microsoft Excel Worksheet Functions 2 18th Jun 2009 05:10 AM
I need to convert 157.25 minutes, into hours, minutes and seconds. Al Microsoft Excel Misc 1 11th Mar 2009 10:04 AM
how to convert minutes and seconds into seconds on excel rachel Microsoft Word Document Management 2 18th Mar 2008 01:07 PM
Convert seconds to minutes and seconds tshad Microsoft ASP .NET 7 12th Mar 2005 12:27 AM
convert seconds to minutes and seconds =?Utf-8?B?QnJpYW4=?= Microsoft Excel Worksheet Functions 2 9th Dec 2004 10:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:51 PM.