Sheet 2 name is "BTB_TACTIMESHT_578162"

[Guest]

Hello from Steved

I would like to use the name "BTB_TACTIMESHT_578162" how do I acheive this
please, in the below formula.

Sheet 1 the formula is
=IF(OR(F1="A",E1>=12),(INT(E1)*60)+((E1-INT(E1))*100),(INT(E1)*60)+((E1-INT(E1))*100)+720)

Sheet 2 name is Sheet 2 name is "BTB_TACTIMESHT_578162"
Thankyou.

 

[Biff]

Hi!

Don't'cha just love those long sheet names? <VVBG>

Temporarily rename sheet BTB_TACTIMESHT_578162 to 1. (or X or something
really short)

Edit your formula to reference the new temporary sheet name:

=IF(OR('1'!F1="A",'1'!E1>=12),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100)+720)

Change the sheet name from 1 back to BTB_TACTIMESHT_578162.

Just look at how long that formula is with that long sheet name. Hint, hint
<g>

Biff

 

[Guest]

Thanks Biff

Hi!

Don't'cha just love those long sheet names? <VVBG>

Temporarily rename sheet BTB_TACTIMESHT_578162 to 1. (or X or something
really short)

Edit your formula to reference the new temporary sheet name:

=IF(OR('1'!F1="A",'1'!E1>=12),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100),(INT('1'!E1)*60)+(('1'!E1-INT('1'!E1))*100)+720)

Change the sheet name from 1 back to BTB_TACTIMESHT_578162.

Just look at how long that formula is with that long sheet name. Hint, hint
<g>

Biff

 

[Arvi Laanemets]

Hi

At start, simplify youf formula somewhat:
=INT(E1)*60+(E1-INT(E1))*100+720*AND(F1<>"A",E1<12)

For second, my advice is never to use long sheet names (additionally to
Biff's reasoning, it makes difficult to switch between sheet tabs, as you
have less of them visible), and also avoid sheet names which contain spaces
(no case here lukily).

At last, when for some reason you don't want to opt Biff's solution, then
there is another way:
Select the cell, to where you want to enter the formula;
Create short named range(s), like
rng1=BTB_TACTIMESHT_578162!$E1
rng2=BTB_TACTIMESHT_578162!$F1
(Here I assumed that both cells you are referring to are situated on another
sheet, and that you'll copy your formula down. When otherwise, then you'll
need to make some changes. And range names gan be something meaningfull
of-course)

The formula will now be:
=INT(rng1)*60+(rng1-INT(rng1))*100+720*AND(rng2<>"A",rng1<12)

 

[Guest]

Hello Arvi from Steved

Thankyou.

Hi

At start, simplify youf formula somewhat:
=INT(E1)*60+(E1-INT(E1))*100+720*AND(F1<>"A",E1<12)

For second, my advice is never to use long sheet names (additionally to
Biff's reasoning, it makes difficult to switch between sheet tabs, as you
have less of them visible), and also avoid sheet names which contain spaces
(no case here lukily).

At last, when for some reason you don't want to opt Biff's solution, then
there is another way:
Select the cell, to where you want to enter the formula;
Create short named range(s), like
rng1=BTB_TACTIMESHT_578162!$E1
rng2=BTB_TACTIMESHT_578162!$F1
(Here I assumed that both cells you are referring to are situated on another
sheet, and that you'll copy your formula down. When otherwise, then you'll
need to make some changes. And range names gan be something meaningfull
of-course)

The formula will now be:
=INT(rng1)*60+(rng1-INT(rng1))*100+720*AND(rng2<>"A",rng1<12)