change a decimal into seconds

G

Guest

Can anyone help me with Excel I need to change a decimal number into seconds
example 10.32 into 392 seconds. What formula would I need
 
C

Chip Pearson

In what unit is the 10.32 expressed? If its minutes.seconds, the correct
answer would be 632, from the following formula:
=INT(A1)*60+(A1-TRUNC(A1,0))*100

You'll get 392 seconds from an input value of 6.32, not 10.32.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
How do I extract the decimal places from a number in excel? 3
Change number from multiple decimals to 2 3
Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Find and Replace wildcards 2
Decimal point in general format 1
excel 2003 zero as last decimal 5

Top