LinkBack URL
About LinkBackshi! why does the formula given above does not work on my excel?
hi! why does the formula given above does not work on my excel?
How do you convert .1 mg into kg???
Problem:
Column A contains 4 pairs of numbers, which represent kilometers, degrees Celsius, milligrams, and days.
We want to convert the quantities to their equivalents in miles, degrees Fahrenheit, kilograms, and seconds respectively.
Solution:
Use the CONVERT function as shown in the following formulas:
To convert kilometers to miles:
=CONVERT(A2,\"km\",\"mi\")
To convert Celsius to Fahrenheit:
=CONVERT(A6,\"C\",\"F\")
To convert milligrams to kilograms:
=CONVERT(A10,\"mg\",\"kg\")
To convert days to seconds:
=CONVERT(A14,\"day\",\"sec\")
Hi,
Does anyone know how to convert minutes to seconds?
The data is presented as 4:11 (For example).
Thank you!
Hi Saray,
To convert minutes to seconds, you just multiply by 60.Originally Posted by Saray
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.
Last edited by Alan; 09-09-2005 at 07:41 AM.
To help us help you, try to do the following:
1) Be precise about what you want to do, and provide a sample of your data / inputs - exactly as they are.
2) State the formula(e) / code that you have tried. People are happy to help , but if you haven't even given it a go, you are less likely to get help, or the help you get will be very basic.
3) State the results you are getting from your formula(e) / code already.
4) State the outputs that you *want* to be getting.
Hi Alan,
Thank you for your suggestion! It works!
Your help is much appreciated
Hi Saray,
You are welcome.Hi Alan,
Thank you for your suggestion! It works!
Your help is much appreciated
You asked how to convert so that is the answer given, but I would strongly suggest that you don't convert to non-standard units of time (ie anything other than 'days').
Better just to format your outputs so that they *display* as seconds so that you retain all the functionality of the built in excel options and it is easier to amend or add to later.
Your choice though.
HTH,
Alan.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks