excel help

Mark Lind - 11-7-2008 at 02:59 PM

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 - 11-7-2008 at 03:04 PM

The previous formula looked like this:

=TEXT(E8/(24*60*60), "mm:ss")

BDx13 - 11-7-2008 at 03:16 PM

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

Mark Lind - 11-10-2008 at 10:50 AM

That's it, dude. Where did you come up with that number?

Voodoobillyman - 11-10-2008 at 11:18 AM

excel holds the key to the secret of life within it's formulas I swear!

BDx13 - 11-10-2008 at 11:39 AM

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.

CR83 - 11-10-2008 at 05:30 PM

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." :smilegrin: