Is it possible to create a macro to apply a formula to selected cells? I
am importing data from AVAYA which displays elapsed time in seconds.
When copying into excel, the number displays but is not formatted as a
number. I want to create a macro that will recognize the number and
then apply a formula to convert it to hours and minutes. Any ideas?


--
Gina921
------------------------------------------------------------------------
Gina921's Profile: http://www.excelforum.com/member.php...o&userid=24759
View this thread: http://www.excelforum.com/showthread...hreadid=383301

Yes, it is possible.

But using a formula may not be the best way. If you post the values that get
pasted and what they should be when the macro finishes, I'm sure you'll get much
better help.

Gina921 wrote:

Is it possible to create a macro to apply a formula to selected cells? I
am importing data from AVAYA which displays elapsed time in seconds.
When copying into excel, the number displays but is not formatted as a
number. I want to create a macro that will recognize the number and
then apply a formula to convert it to hours and minutes. Any ideas?

--
Gina921
------------------------------------------------------------------------
Gina921's Profile: http://www.excelforum.com/member.php...o&userid=24759
View this thread: http://www.excelforum.com/showthread...hreadid=383301

--

Dave Peterson