subtract from vlookup?

  • Thread starter Thread starter Todd
  • Start date Start date
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
 
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)
 
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
 
Back
Top