Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
excel help
You guys helped me before when I needed to convert seconds into minutes (123 seconds to 2:03). Now I need to do the opposite. Can anyone help me out?
|
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
The previous formula looked like this:
=TEXT(E8/(24*60*60), "mm:ss")
|
|
|
BDx13
|
|
assuming you're only dealing with minutes and seconds (as opposed to hours, minutes and seconds), try this:
- Assume your minutes:seconds value is located in A1
- Format A1 as TEXT
- Format B1 as NUMBER
- In B1 enter the formula: =A1*1440
- The conversion result will appear in B1
If I fail math, there goes my chance at a good job and a happy life full of hard work.
|
|
|
Mark Lind
Posting Freak
Posts: 1900
Registered: 9-18-2004
Member Is Offline
|
|
That's it, dude. Where did you come up with that number?
|
|
|
Voodoobillyman
The Artist Formerly Known As...
Posts: 4247
Registered: 8-12-2005
Location: Eastern Seaboard of the United States
Member Is Offline
Mood: my daughters beautiful curiousity
|
|
excel holds the key to the secret of life within it's formulas I swear!
|
|
|
BDx13
|
|
Google!
Honestly, I'm not 100% sure what that formula is doing. Excel tracks time as a fraction of the day, and there are 1440 minutes in a day, but I don't
quite get how having the first column as text and the second as a number is affecting the result.
If I fail math, there goes my chance at a good job and a happy life full of hard work.
|
|
|
CR83
Moderator
Posts: 5221
Registered: 1-23-2004
Location: STL!
Member Is Offline
Mood: Harm's Way
|
|
| Quote: | Originally posted by BD
Google!
Honestly, I'm not 100% sure what that formula is doing. Excel tracks time as a fraction of the day, and there are 1440 minutes in a day, but I don't
quite get how having the first column as text and the second as a number is affecting the result. |
BD, it is Magic. As my four year old says, "Well, duh." 
|
|
|
![[*]](images/thorp/default_icon.gif){kind=icon}
