| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change a decimal into seconds
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change decimal places in balance sheet template | Excel Worksheet Functions | |||
| number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
| How do i convert angles from degrees,minutes, seconds to decimal | Excel Discussion (Misc queries) | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| How can I change decimal amounts to end with .95 | Excel Worksheet Functions | |||
Linear Mode
