Hello Arvi from Steved

Thankyou.

"Arvi Laanemets" wrote:

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)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Steved" wrote in message
...
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.