Re: Problem with Calc formula

[Scooter]

Dear Alan B,

THANK YOU! It worked beautifully.

Take Care.
Scooter
College Park, MD USA

Alan B wrote on 12/15/2015 6:51 PM:

On Tue, Dec 15, 2015 at 6:01 PM, Scooter C  wrote:


I've been trying, in vain, to construct a formula for a time value from
enter times.
I want the minutes or hours from a beginning clock time to an ending clock
time.
The formula in the help screen: =(c2

Problem with Calc formula

[Scooter C]

Good Evening Group,

I've been trying, in vain, to construct a formula for a time value from 
enter times.
I want the minutes or hours from a beginning clock time to an ending 
clock time.
The formula in the help screen: =(c2

Re: Problem with a formula

[Luis Iglesias]

Hi.The problem is not with fractions but with the values you expect in your conditional. Your formula only applies when A23  B9 or when A23 = (1,2,3,4,5,6,7,8). You can fix in your last IF:...IF(A23=8;$F$16;1)...or maybe you're looking for something like:=IF(A23$B$9;$F$8;IF(A238;$F$16;IF(A237;$F$15;IF(A236;$F$14;IF(A235;$F$13;IF(A234;$F$12;IF(A233;$F$11;IF(A232;$F$10;IF(A231;$F$9;1)*A23*D23De: "Явор Маринов" ymari...@neterra.netPara: users@openoffice.apache.orgEnviados: Lunes, 3 de Junio 2013 11:18:35Asunto: Problem with a formulaHello,I'm having a problem with a formula that i have=IF(A23$B$9;$F$8;IF(A23=1;$F$9;IF(A23=2;$F$10;IF(A23=3;$F$11;IF(A23=4;$F$12;IF(A23=5;$F$13;IF(A23=6;$F$14;IF(A23=7;$F$15;IF(A23=8;$F$16)*A23*D23If the content of A23 is integer the formula works fine, but if the content of A23 is а fraction the result is 0.Can anyone point where can be the mistake?-To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.orgFor additional commands, e-mail: users-h...@openoffice.apache.org-- Luis Iglesias RejasServizo de Administración ElectrónicaPraza do Rei, 1 - Planta 7ª36202 VIGOTfno: 986 810 159 / Fax: 986 220 341 Web: www.vigo.org