# one last question( maybe simple)

#### Spockster

##### Board Regular
I have =vlookup(a1,the range,2,0) how can i add in the *86400 there. I can't seem to get it to work.

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
try this

=VLOOKUP(A1,TheRange,2,0)*886400

already tried that and it didn't work. Thanks though... any other ideas

it works for me are you getting a result at all (Without) the *86400

are you trying to bring back a "time/date" answer ?

hh:mm:ss ?

60 x 60 x 24 is 86,400......

when I do my vlookup and add the *86400 i get a #value error. And not sure why?

On 2002-09-07 12:28, Spockster wrote:
when I do my vlookup and add the *86400 i get a #value error. And not sure why?

What do you get without *86400

I get the Vlookup answer I was looking for which is 15:10 and another vlookup finds 00:55 I need to divid :55/15:10 to find the percentage.

I have formatted the cells to h:mm:ss and still nothing the first Vlookup is

vlookup(a1,range,2,0) which gives hours in this format 15:10

Second vlookup is

vlookup(a1,range,2,0) which gives hours in this format 0:55

I need to divide 0:55/15:10 to find the percentage and that is what is giving me the #value! error

Need Help

=VLOOKUP(A3,F2:G4,2,0)/VLOOKUP(A2,F2:G4,2,0)

Format as percentage should give the same result as dividing the numbers manually or
separately.

If you want a percentage, format as Percentage.

Replies
10
Views
171
Replies
0
Views
224
Replies
3
Views
181
Replies
2
Views
127
Replies
3
Views
361

1,203,096
Messages
6,053,516
Members
444,669
Latest member
Renarian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back