Re: subtract from vlookup?

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 04/05/04 

Date: Tue, 6 Apr 2004 01:17:04 +0200

Hi Todd
no problem but in most cases not necessary to use two different forums
as most regulars read them all :-)
For searching the forums you may consider using Ron's excellent Google
Add-in:
http://www.rondebruin.nl/Google.htm 

--
Regards
Frank Kabel
Frankfurt, Germany
"Todd" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:188f701c41b63$0957d580$a501280a@phx.gbl...
> 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
>
> >-----Original Message-----
> >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)
> >
> >--
> >Regards
> >Frank Kabel
> >Frankfurt, Germany
> >
> >"Todd" <anonymous@discussions.microsoft.com> schrieb im
> Newsbeitrag
> >news:15bef01c41b5f$b7a4f220$a601280a@phx.gbl...
> >> 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
> >
> >.
> >