Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel |