excel question

Y

yoram

I need help in how to write a command that will choose
only the #s after the "." for example: I have the #:5.96
and i want excel to write on the next column only the:.96
Thank you
Yoram

hours function needed
5.96 .96*60/100
 
D

Dan E

Yoram,

The MOD function is what you need

=MOD(A1,1)
result is 0.96
=MOD(A1,1) * 60 / 100
result is 0.576

Dan E
 
K

Ken Wright

The MOD answer you have will do it, but just to give you a choice:-

=A1-INT(A1) and hence

=(A1-INT(A1))*60/100
 

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

Insert name and adress from a list in a word document 1
Drop down list control value in vba 2
How to concatenate cells that meets a specific criteria in threecolumns 6
Countif function 2
This should be easy, but can't find an answer...requesting your in 1
Merging from an Excel file with graphics 1
sum data in a range? 4
Use an "OR" around nested IF statements 2

Top