Use only part of the number

  • Thread starter Thread starter Rudi Groenewald
  • Start date Start date
R

Rudi Groenewald

Hi guys,

I've got a sheet as follows:

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs
8061237 9735.8 9735.8 0 0
8066201 4076.4 4049.4 27 1.08
8066314 6082 5833.2 248.8 9.952
8066315 11847.4 11510.7 336.7 13.468
8066537 3630.6 3472.6 158 6.32
8066543 5799.8 5469 330.8 13.232


In my next coloumn to the right, I need to get the values from "Today", but
only the first 3 numerals from the right. eg: (manually typed)

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs Hrs Left
8061237 9735.8 9735.8 0 0 735.8
8066201 4076.4 4049.4 27 1.08 76.4
8066314 6082 5833.2 248.8 9.952 82
8066315 11847.4 11510.7 336.7 13.468 847.4
8066537 3630.6 3472.6 158 6.32 630.6


How can I achieve the "Hrs Left" Coloumn by using a formula?

Thanks alot in advance

Rudi Groenewald
 
Your example *doesn't* match your request.

You say you need:
<"only the first 3 numerals from the right">
But your examples include the decimal.

Do you want the 4 characters?
If so, here's one way to do it:


=IF(ISERR(FIND(".",B2)),--RIGHT(B2,3),--RIGHT(B2,5))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi guys,

I've got a sheet as follows:

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs
8061237 9735.8 9735.8 0 0
8066201 4076.4 4049.4 27 1.08
8066314 6082 5833.2 248.8 9.952
8066315 11847.4 11510.7 336.7 13.468
8066537 3630.6 3472.6 158 6.32
8066543 5799.8 5469 330.8 13.232


In my next coloumn to the right, I need to get the values from "Today", but
only the first 3 numerals from the right. eg: (manually typed)

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs Hrs Left
8061237 9735.8 9735.8 0 0 735.8
8066201 4076.4 4049.4 27 1.08 76.4
8066314 6082 5833.2 248.8 9.952 82
8066315 11847.4 11510.7 336.7 13.468 847.4
8066537 3630.6 3472.6 158 6.32 630.6


How can I achieve the "Hrs Left" Coloumn by using a formula?

Thanks alot in advance

Rudi Groenewald
 
Hi guys,

I've got a sheet as follows:

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs
8061237 9735.8 9735.8 0 0
8066201 4076.4 4049.4 27 1.08
8066314 6082 5833.2 248.8 9.952
8066315 11847.4 11510.7 336.7 13.468
8066537 3630.6 3472.6 158 6.32
8066543 5799.8 5469 330.8 13.232


In my next coloumn to the right, I need to get the values from "Today", but
only the first 3 numerals from the right. eg: (manually typed)

Machine_Name Today 1St Day Hrs Wrkd Avg Hrs Hrs Left
8061237 9735.8 9735.8 0 0 735.8
8066201 4076.4 4049.4 27 1.08 76.4
8066314 6082 5833.2 248.8 9.952 82
8066315 11847.4 11510.7 336.7 13.468 847.4
8066537 3630.6 3472.6 158 6.32 630.6


How can I achieve the "Hrs Left" Coloumn by using a formula?
Click to expand...

Hrs Left = MOD(Today,1000)


--ron
 
Back
Top