subtract from vlookup?

T

Todd

Hi, I have a vlookup formula that is returning a time
value I need to subract (8)hours from. How do I do that?

=VLOOKUP(B52,C8:H14,6,FALSE)

TIA


Todd
 
F

Frank Kabel

Hi Todd
somehow this question sound familiar?
Try
=VLOOKUP(B52,C8:H14,6,FALSE)-8/24
or
=VLOOKUP(B52,C8:H14,6,FALSE)-TIME(8,0,0)
 
T

Todd

Sure does, thank you very much! I thought I should use
the proper forum. I know it sure helps me out to be able
to search this site for answers.

Thanks again,


Todd
 
Top