View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default change a decimal into seconds

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)

"Lonely Pony" <Lonely wrote in message
...
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