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

"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.