View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default Sheet 2 name is "BTB_TACTIMESHT_578162"

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.