Help with Time formula
 

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,P430,
(A4+E4*(P4<59)+F4*(P4=59)-A3-I3-(I3<E3))-16/24))

Help with Time formula
 

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)

"Larry A. Witcher" wrote in message
...
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,P430,
(A4+E4*(P4<59)+F4*(P4=59)-A3-I3-(I3<E3))-16/24))

Help with Time formula
 

=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,Y30,
(A4+E4*(Y<59)+F4*(Y=59)-A3-I3-(I3<E3))-16/24))

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

--
Regards,
Tom Ogilvy

Larry A. Witcher wrote in message
...
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,P430,
(A4+E4*(P4<59)+F4*(P4=59)-A3-I3-(I3<E3))-16/24))