View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Logical based Horizontal Lookup

Hi Daniel,

Am Wed, 16 Mar 2016 04:44:59 -0700 (PDT) schrieb Daniel Petta:

Is there any way to take the last part of the formula and have it use the same logic defined in the UDF?


I put sTime and eTime in one UDF. Now you have to call the function in
the sheet with:
=myTime(C2:AX2)
Have a look:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "PLANNER 031616" and download the file.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional