Converting Units

Hi Saray,

Originally Posted by Saray

Hi,

Does anyone know how to convert minutes to seconds?

The data is presented as 4:11 (For example).

Thank you!

To convert minutes to seconds, you just multiply by 60.

However, if you have a value in a cell, formatted such that it is *displaying* as 4:11 then it is probably formatted as either:

m:ss

OR

h:mm

It could also be formatted as text, but I am assuming not for now. From the context of your question, I imagine it is:

m:ss

since you asked how to convert mins to seconds, but someone may have formatted it 'lazily' as h:mm which *appears* similar to m:ss.

The only way to be sure is to either tell us the actual non integer portion of the *value* in the cell (probably either 0.00290509259... or 0.17430555... depending on which format), or tell us the actual formatting on the cell.

If it is *correctly formatted* as m:ss then to get from days to seconds you just multiply the cell value by:

(24*60*60) = 86,400 being the number of seconds in a day.

For example:

= 0.00290509259 *86400

= 251 (seconds)


Note: The above decimals are rounded approximations of course.

HTH,

Alan.