Help with Time formula

  • Thread starter Thread starter Larry A. Witcher
  • Start date Start date
L

Larry A. Witcher

I need some help on the following formula. It works
perfectly as written. I want to replace the reference
to "P4=30" & "P4=59" with a new column that if tagged
with a "Y"
(S4=Y), that the formula will work as composed.

When I replace the reference as staed above with the new
column, the figures do not compute properly.

In order to understand what I am trying to accomplish, I
will probably have to send a copy of my spreadsheet for
explanation.



=IF(ISBLANK(A4),"",PRODUCT(H3<>N3,D4=H3,P4<=30,INT(A4+E4*
(P4<30)+F4*(P4=30)-A3-I3-(I3<E3))*8/24+MAX((A4+E4*(P4<30)
+F4*(P4=30)-A3-I3-(I3<E3))-INT(A4+E4*(P4<30)+F4*(P4=30)-
A3-I3-(I3<E3))-16/24,0))+PRODUCT(H3<>N3,D4=H3,P4>30,
(A4+E4*(P4<59)+F4*(P4=59)-A3-I3-(I3<E3))-16/24))
 
Larry,
Did you use quotes round the "Y"?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=IF(ISBLANK(A4),"",PRODUCT(H3<>N3,D4=H3,Y<=30,INT(A4+E4*
(Y<30)+F4*(Y=30)-A3-I3-(I3<E3))*8/24+MAX((A4+E4*(Y<30)
+F4*(Y=30)-A3-I3-(I3<E3))-INT(A4+E4*(Y<30)+F4*(Y=30)-
A3-I3-(I3<E3))-16/24,0))+PRODUCT(H3<>N3,D4=H3,Y>30,
(A4+E4*(Y<59)+F4*(Y=59)-A3-I3-(I3<E3))-16/24))

Insert => Name => Defined
Name: Y
Refersto: =Sheet1!$S$4
 
Back
Top