A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need to convert Minutes:Seconds format to minutes with seconds con



 
 
Thread Tools Display Modes
  #1  
Old June 18th, 2009, 03:51 AM posted to microsoft.public.excel.worksheet.functions
Cliff
external usenet poster
 
Posts: 136
Default Need to convert Minutes:Seconds format to minutes with seconds con

Need to convert Minutes:Seconds format to minutes with seconds converted to a
decimal
Ads
  #2  
Old June 18th, 2009, 04:26 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default Need to convert Minutes:Seconds format to minutes with seconds con

One way with minutes seconds entry in A1.

=(TEXT(A1,"[s]")+0)/60

If this post helps click Yes
---------------
Jacob Skaria


"Cliff" wrote:

Need to convert Minutes:Seconds format to minutes with seconds converted to a
decimal

  #3  
Old June 18th, 2009, 05:10 AM posted to microsoft.public.excel.worksheet.functions
joeu2004
external usenet poster
 
Posts: 1,748
Default Need to convert Minutes:Seconds format to minutes with seconds con

"Cliff" wrote:
Need to convert Minutes:Seconds format to minutes with seconds
converted to a decimal


That depends on (a) how you entered the data, and (b) what you mean by
"converted to a decimal". As always, specific examples will help us help
you.

For example, suppose you have 12:34.

First, what result do you want: 12.34, about 12.57 (exactly 12 + 34/60), or
something else (what?)?

Second, how did enter 12:34: simply as 12:34; as 0:12:34; or text of the
form 12:34? What is the format of the cell?

Format the cell as Number with 6 decimal places or more. Is the value about
0.523611 or 0.008727?

At issue is: you might have thought you entered min:sec, but it was
actually interpreted as hr:min.

If you entered 0:min:sec and the cell is formatted as mm:ss, and if the cell
displays about 0.008727 when you format it as Number as 6 dp, and if you
12:34 to be converted to about 12.57, you can convert as follows:

=A1*1440

which you can format as Number with 2 decimal places, if that's what you
want.

  #4  
Old June 18th, 2009, 05:22 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Need to convert Minutes:Seconds format to minutes with seconds con

=A1*1440 and format as number or general.
--
David Biddulph

Cliff wrote:
Need to convert Minutes:Seconds format to minutes with seconds
converted to a decimal



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.